Dates on Reports

[Janet Kazar]

I have Microsoft Access 2002 and I have been trying to run
reports with dates with a query of "10-01-03" - "10-31-03"
and have been getting back items from the database that
include 2002 dates also. What would I need to do so that I
can only get my search critera to come out?

 

[John Vinson]

I have Microsoft Access 2002 and I have been trying to run
reports with dates with a query of "10-01-03" - "10-31-03"
and have been getting back items from the database that
include 2002 dates also. What would I need to do so that I
can only get my search critera to come out?

Care to describe the query that you're using? perhaps post the SQL?

The syntax for getting a date range requires that you use an Access
Date/Time field (not a text string: the text string "10-03-74" is
indeed bigger than the text string "10-01-03" and less than
"10-31-03"); and the query criterion should be

BETWEEN #10/01/03# AND #10/31/03#

or, more flexibly,

BETWEEN [Enter start date:] AND [Enter end date:]