Date Range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andre Adams - 29 May 2007 20:44 GMT

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

Reply to this Message

Douglas J. Steele - 29 May 2007 20:58 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hey guys.
>
[quoted text clipped - 10 lines]
>
> Andre Adams

Reply to this Message