Selecting a particular data in a query

[usfpjc]

I have created a query to be utilized to create a particular report.

The query points to a particular drop down field in a table, for selection of Quarters 1,2,3 and 4.

In order to trigger the report that only selects a particular quarter of the year, I need to put something ( a statement) in the query column "Service Quarter" to prompt the user to enter the particular quarter: 1,2,3 or 4, thus triggering a report for that particular quarter.

 

[PHV]

In the criteria cell: =[Enter quarter: 1,2,3 or 4]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886