Query That Pulls Multiple Businesses

[Jill]

Hi,
I have a single table that my query is built from:

clients_tbl
id
clientname
line_of_business
revenue

In my query I can pull a single line of business name by using this:

Like [Enter Name of LOB] & "*"

What I would like is the abililty to pull multiple lines of business in the
same query.

Thanks,
JCrowe

 

[Guest]

I recommend always using a form with controls for entering criteria. Your
situation is a candidate for a form with a multi-select list box. This
requires a little coding which if you don't understand, now is a good time to
jump in.

There is a generic list box function that can be used in a query at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.