Setting criteria for a select query 1

[kpryan]

Hi
In a query I have three options to select companies,
ie: "C" (Companies) "P" (Private clients) "S" for (Suppliers).
On the criteria line how do I just select companies and private clients.

I know that I can enter "C" which will select companies etc, but to be able to select both at the same time.

Many thanks,

KP

 

[Knicks]

C" or "P"

I believe this is what you are looking for?

 

[PHV]

In ('C','P')

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886