date range query

[lyonmt]

Hello and thank you for any help you may be able to provide.

I am a casual user of Access2000 and need to create a parameter query that will pull records in a range.

i.e.
One of my fields contains a date. I need to make a report for all records during a certain week. I would like to create a report and have a prompt ask for the date range.

I know how to create a basic parameter query.
I know how to make a report from a query.

 

[jjonesal]

In the criteria for your date, try:

Between [Enter Begin Date] And [Enter End Date]

You need to go to Query, Parameters (from the menu) and modify the data types of the parameters to be Date/Time to prevent someone from entering data that is not a valid date (i.e. 1/32/02)

Hope this is what you needed....

JJ J. Jones
jjones@cybrtyme.com

 

[lyonmt]

Thanks, I appreciate it.