parameter query (2003)

Topic

New Reply

I want to create a parameter query that has 8 parameters. The first would ask for the Client Mgr name. Then the 7 other fields the parameter for each would be [Gain or Loss]. What I want to see is Gain in the first field or a gain in the second field or a gain in the third field and so forth. I want a gain in any of the seven fields using or. Is this possible for a parameter query and if so how would I set it up. The seven fields would be all Gains with or – or all Losses with OR. Just that for each field, at least one of the seven has to have a gain for each record. I hope this makes sense.

Reply | Quote

Replies

Linda, if you’re only looking for managers with ‘Gain’ records (no user input on the query, other than manager name) you could use something as shown below):

If you want more user interaction, the only way I can think of to prompt for input in a query (without a prompt for each field) would be to use a form. The concept of defining a variable is stomping loudly in my brain, but I don’t know how to do it/use it in a query. I can show you how to set up the form though.

Edit: as I was tinkering further with this; apparently, so long as your prompt text (ie [Enter ‘Gain’ or ‘Loss’]) is exactly the same in each field you are searching, your user will not be prompted multiple times.

Reply | Quote