criteria for dates for yesterday and today

M

maryj

Access 2K/Win2K. Field has date/time data type. Data is only date - no time
included. Using the criteria: between date()-1 and date() but getting error:
Data type mismatch.

Any suggestions?
 
J

Jeff Boyce

What happens if you use the actual dates (Between #9/15/2005# And
#9/16/2005#) as the criteria?

Regards

Jeff Boyce
<Access MVP>
 
M

maryj

Needed to create a new field using the Datevaule function. Then the criteria
worked on the new field.
 
Top