How do i use user entered data for the same criteria in a query.

[KaayJaay]

I am trying to get a date range from the user, and calculate the amount of widgets in that date range. The fields are amount(widgets), and created date.

I want to get all of the widgets created within the date range. I thought the criteria would be for amount, Where date range = "what the user input", but i thought also that this would be the criteria for the date range it self. How do i get this to work with out asking the user for the date range twice.

Thanx
KaayJaay

 

[Crowley16]

put it on a text box on your form somewhere, and use that as the source for both conditions

 

[KaayJaay]

Right now i have a query that asks for a start and an end date from the user, now how do i use a form, using a drop down list with all of the valid inputs to correspond to the users entry. ex. How do i make the query automatically take the entry in the drop down box and apply it to the query as input.

KaayJaay

 

[Crowley16]

in the query, use they syntax:

[forms]![formName]![controlName]