Criteria in Query

[sondriven]

I am designing a query so I can look up records that apply only to the Supplier and the Start / End Dates.

I want to make a pop up form called Supplier Records. In there have a blank to enter the supplier. And 2 blanks to enter the Start and End dates. Along with the report preview button.

In the query I need to enter in the criteria for this. I dont really know how to word this so that it'll work with the form.

Any help would be appreciated.

Thanks.

 

[Adrianna]

Hmm..not axactly sure..but this is what I would do:

I would have a command button launch a macro, or code to open your report, in report preview.
Have the report based off of a query.

In the Criteria section of the query:
Supplier - Place [Enter a Supplier Record: ]
In StartEndDate - Between [Enter a start date: ] And [Enter and end date: ]

When users want to view the report, they will be prompted for the supplier and the date range that they would like to view!