Select Date Range

  • Thread starter Thread starter Greta
  • Start date Start date
G

Greta

Access 2002...
I still can't get this. I have a report based on 2
tables. I want to be able to choose a date range, like
from 2/2/03 to 9/1/03, and have only the records between
those dates appear on the report. Date is one of the
fields in one of the tables.
The best would be if I could put the dates on my form,
where I have a comand button that opens this report in
preview.
I've been trying to figure this out and just can't seem to
get it.
Thanks,
Greta
 
Greta

I'll take your description literally -- you have a field named "Date" in one
of your tables. Access treats the word "Date" as a reserved word, so using
this name for a field will only confuse both you and Access. Try renaming
the field (?StartDate, or MyDate, or ...) and modifying the query.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top