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.