Specific data selection in query

[vnms2001]

Let's say I have a database that contains an info. that has many company codes. For example company #s 1,2,3,4,5 etc. When I run my query, it is setup the way that I can either select one company ( Ex. Company# 2) or all the companies (Company #s 1,2,3,4,5,etc.) - and here is the formula in criteria field in query design - Like [Company] & "*"



My question is this: How can I setup the query that I can select multiple companies, such as company 2,4 & 5 etc or all copmanies when I want to show all. Please help.

Thank you

[June7]

Review http://allenbrowne.com/ser-50.html