how to set up query criteria

[santosh1]

Hello again,

I stored the query criteria variables into the access table 'TimePeriod'. Then on the select query 'qrySelPlacements', under criteria, I used the build function to set this criteria,

[TimePeriod]![month]
[TimePeriod]![year]

When I run the application, the query is suppose to read the criteria from the table 'TimePeriod', but it isn't, still prompts me for month and year. Am I doing something wrong here? Please let me know. Thankyou.

Santosh

 

[scriverb]

It doesn't work that way. You either have to put the query criteria data in global variables and make a function call to them within the criteria row of the query or you can reference a couple of text boxes on a form that has the query values being displayed in them.

But, just storing them in a table will not work in this instance.

Does this help you?

Bob Scriver