SETTING 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?

 

[mikey69]

You can do this by using a form with two text boxes. One has the start date and one the end date. Then put a command button on the form. Have the command button open the query and put in the criteria box of the query the criteria Between Forms!formname!startdate and forms!formname!enddate.

If you dont want to use a form, simply put the criteria in and when you open the query, you'll be prompted for the dates.

 

[LittleSmudge]

I think what your asking for is this .. ..

In the query place the following in the criteria line for the date field
Between [Enter start date] And [Enter end date]

When the query runs it will throw up a box containing the label [Enter start date] so you can enter the info and click okay. Then it throws up the second etc then it will select data with date field between those limits.

SNAG - You cant protect your system from stupid users who put an earlier date in the second box !!!!
Use a customer dialog box as discussed in the previous answer if this problem is a serious concern.

G LS