setting a criteria in a query

[scott1891]

I made a query, in my fiel named date I need to have it open by typing a range and generate info by it..example, when open the query I want it to prompt me to enter a beginning date and ending date(##/##/### to ##/##/####)which will give me all the info between the two dates. Any ideas?

 

[mdthornton]

Put the following on the criteria line of your date field:

Between [Enter Start Date: ] And [Enter End Date: ] Best Regards,
Mike

 

[smedvid]

PARAMETERS [Enter Start Date:] Date, [Enter End Date:] Date ;
SELECT Table1.*, Table1.TestDate
FROM Table1
WHERE (((Table1.TestDate) Between [Enter Start Date:] And [Enter End Date:])); Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/