Critera

[Guest]

on my report, i have an Enter Parameter Value from a query:

between:
Start Date
End Date

and when i put in:
12/01/2005
12/30/2005

my report comes back with a 12/20/2004 record, which i do not want. not sure
how to correct. thanks.

 

[Allen Browne]

Sounds like the query is misinterpreting the data type of the parameter.

In query design view, choose Parameters on the Query menu.
Enter 2 rows into the dialog:
[Start Date] Date/Time
[End Date] Date/Time

If this criteria is beneath a calculated field, add CVDate() around the
expression so JET interprets it correctly.

More info in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html