multiple results of query for multiple input crtieria

[danselm]

two values that when their combination is identified, the DB has a value in a 3rd field that is sought after.



Right now, the form/macro/query/report takes one data value of each of the two inputs from the form and returns single record result.

Is it possible to put more than one set of input data pairs like on a form and hit GO and get a matching number of Results values.

[June7]

Yes, can have multiple criteria pairs. The logical operator between the pairs would be OR.

(field1 = value1a AND field2 = value2a) OR (field1 = value1b AND field2 = value2b)

How to get those pairs into the query filter is the trick.