Cross tab date problem

[Dave]

I have a first qry that selects data on two date fields from a
form ..

the query selection criteria is >[Forms]![frmMenu1]![Startdate]

This works fine

and a second cross tab that has as its data source only the first
qry. When I run the 2nd qry I get an error message saying that it
cant recognise [Forms]![frmMenu1]![Startdate]

Thanks

DAve

 

[Allen Browne]

Try explicitly declaring the parameter.

Open the query in design view.
Choose Parameters on the Query menu.
In the dialog, enter:
[Forms]![frmMenu1]![Startdate] Date

You must declare the parameter in a crosstab (unless you specify Column
Headings), but it is always a good idea to declare parameters except on Text
fields. Declaring date parameters is especially important, since New Zealand
use non-American date formats. More info about that:
http://allenbrowne.com/ser-36.html

And info about why you don't want to declare parameters on Text fields:
http://allenbrowne.com/bug-13.html