How to return all records in a parameter ([enter])?

L

Lee

In my query, I set up a parameter around three types of words (Financial:
Total of 1631 Record, M&E: Total of 7839 Records, and Consolidated: Total of
50 Records)?

The parameter works when you set it to one of the words?

What word or wildcard do you type to return all three fields at once, a
total of 9520 Records?

Or is there a different way to set up the parameter in the query?
 
A

Amy Blankenship

Try in the criteria, on three different rows
[Enter criteria 1]
[Enter criteria 2]
[Enter criteria 3]

HTH;

Amy
 
L

Lee

Amy,
Thank you so much. It works perfectly. Got one more question?
I set this query to a form. If I pick one of the three, or two of the
three, or all three, could I return it in a form to say either CAT Financial,
CAT Consolidated, or M&E, or all three? How do I set that up.

Thanks
 
A

Amy Blankenship

I think you'd have to alias the column into three different columns, then
use something like

Like IIF(IsNull(Forms![this Form]!Control ), '*', Forms![this Form]!Control)

in the criteria for each column, obviously changing it to reflect the
different controls.

HTH;

Amy
 
Top