I have a table with one column that has "I" or "O" (about 22,000 entries). I have several queries that have [select I] on one line and [Select O] on the other. How do I have it to where one can choose both?

If I understand well, you would like to let a user choose between "I", "O" or "both I and O".

Maybe the following link could help: http://www.mvps.org/access/forms/frm0043.htm

Alex

You could also do "*" & [Enter I for Input, O for Output, or leave blank for both] & "*"

I think there's a limit on the length, but you get the idea. The parameter resolves down to "*" if they leave it blank.

David R - big fan of simple solutions.