tricky query design problem

[Manaz]

I have a two tables related to each other;

table A contains information about stores that my company services, and in this table there are 3 different types of stores: A,B and C

table B contains information about the invoices for each of those stores.

I have a query which retrieves specific information about each store (A,B and C) and displays it (through a report).

I have included a screen shot of the query in design view if that would help.

Is it possible to have the query only select one or two of the stores A,B and C?

My problem is that by using the option 'type' in the field box, the query retrieves info from all the stores (A,B and C) i only want A and B

Thanks for any help

 

[pbaldy]

Try

In("A", "B")

in that field's criteria.

 

[Manaz]

thanks,

i get an invalid syntax error:

"You may have entered a comma without a preceeding value or identifier"

do you know what this means?

 

[pbaldy]

What is the SQL of the query now?

 

[Manaz]

sorry im not sure what you mean by SQL?

I am using microsoft access, im not quite up to play with all the terminology.

 

[Manaz]

thanks for the help i have sorted the problem;

i was entering the In formular in the wrong field, it needed to go in the criteria field.

Thanks Again