Date Range

[Andre Adams]

Hey guys.

I want to know...Is there a way in Access that I can have the Date Range
that I type into the query to show up automatically in a report. So if I ask
the database to find me all records within 01/01/2007 and 01/31/2007, can it
insert that date in to the actual report to let the user know that date range
of the report their looking at?

Thanks.

Andre Adams

 

[Douglas J. Steele]

How are you telling Access to only return those dates?

If you've got a prompt, so that your query's SQL is something like:

WHERE MyDate BETWEEN [Enter Start Date] AND [Enter End Date]

you simply refer to Me![Enter Start Date] and Me![Enter End Date] in your
report.