Help with Automating Parameters

[paynete]

Hello, I am hoping someone can help me. I'm fairly new to access.
I have a simple query that I am running via a form. My problem is that I need to change the value of one field to limit my query return. I always need to change it to the same 4 values (numeric). I don't want to have to create 4 seperate queries, so is there away to tell Access to run the query with one value...then run it with the second value and so on?

Any help would be appreciated ray:

 

[Andrew Fergus]

Hello and welcome.

There are a couple of ways of doing this.

If you go into the query design and in the criteria section of the query, under the variable name which you wish to filter, you can do one of 2 things, either :

a) in the criteria section enter something like =[Enter limit value] and every time you run the query (via the form) then a message box will pop up that says "Enter limit value" where you enter the value you wish to filter on and then click Ok. After the first value, requerying the form may force the query to run again to allow you to enter the next value (not tested).

b) Alternatively, if the 4 values are not going to change and you want to see all 4 instances on the form at the same time, then under the criteria section of the variable enter "=value1 or value2 or value3 or value4" (except don't use the quotes and make sure you use the actual values, not the tags I used of "value1" etc). Whenever you run the query all 4 instances will show.

I realise this hasn't answered your question 100% but I can't think of another way around this. Someone else may be able to contribute something else.

HTH, Andrew.