Select Data between dates

[Tiger99]

Hi
I am wondering how can I select data between two dates (ie from 08/12/2004 to today?)

Name DateS
Bob 08/11/2004
Tom 08/12/2004
Bill 09/21/2004 <-- today

return

Tom 08/12/2004
Bill 09/21/2004

Thanks in advance for your help

 

[SydneyGeek]

This can be done a couple of ways. One is a parameter query, which will ask you for the first date and then give you all records up to today.

Hint: Don't use Date as a field name. It conflicts with the Date function, which gives today's date. Rename the field to something like TransactionDate.

OK, in the query, you have [Name] and [TransactionDate].
In the criteria row below TransactionDate, enter this expression:
Between [Starting Date] And Date()

Save the query and run it. You'll get a popup asking you for Starting Date. Enter the beginning date in the range, press Enter, and you'll have your records.

Denis