Cross-tab query... with user input date parameters? 1

[jamesk1979]

Hi all,

Is it possible to set up a cross-tab query with user input date parameters (i.e. Between [Enter Start] And [Enter End])?

I can run a date parameter query if I set the date parameters to specific dates (i.e. Between #19/03/2004# And #21/03/2004#) but if I try to do it with the user inputting the date values I get the following error;

'The Microsoft Jet database engine does not recognise "[Enter Start]" as a valid field name or expression.'

The date field is set as a Where clause in the query and is not displayed in the query results, although I would need to output it on a report if I can get this to work.

Many thanks,
james.

 

[lupins46]

One solution would be to base your crosstab query on another query which does the record selection.

 

[jamesk1979]

Thanks lupins, that's exactly what I've done.

Cheers...

 

[Chavito21]

Try >= [From Date] amd <= [To Date].

 

[dhookom]

Folks,
You must specify the data types of all parameters used in crosstabs (even if from another query). Select Query|Parameters and enter:
[Enter Start] DateTime
[Enter End] DateTime

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[jamesk1979]

Thanks for the help guys.