Dates on Reports

  • Thread starter Thread starter Janet Kazar
  • Start date Start date
J

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?
 
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?
Click to expand...

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:]
 
Back
Top