Critera

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top