Running a crosstab based on a user's date input (with [])

[viio]

Is it possible to do this? I'm trying to get a crosstab to run for a particular date range, but without the user having to edit the query it's based on. I've had a search through the forum but I can't find anything on this.

The query has this in the date field:

Between ["Enter Start Date for report: dd/mm/yyyy"] And ["Enter Finish Date for report: dd/mm/yyyy"]

Which works fine in the query, but when that is passed to the crosstab and run, I get this error:

The Microsoft Jet database engine does not recognize '[]' as a valid field name or expression.

Any ideas or suggestions for getting it working? I'm on Access 2000 btw.

 

[SydneyGeek]

In Design view, go to the Query menu item and select Parameters.

For each parameter, enter its descriptive text (minus the square brackets) in the first column of the dialog, and the data type (Date/Time) in the second.

Crosstabs often require you to define the parameters, or else they get cranky.

Denis

 

[viio]

Excellent, got it I've been trying to figure that out for ages!

Thanks!