Summing unmatching fields

[Carly]

I have got a query which runs to create a table containing Vendor Number & 12 Months Sales for the Top 4 Vendors.

What I then need to do is create another query which does exactly the same as the above but for all other vendors apart from the 4 in the above table. The vendors will always be changing so I cannot list them within my criteria of the query.

Is there anyway this can be done as all the joins between tables are where things are matching not unmatching?

 

[Birdy]

Join Properties

Carly,

Try changing the Join Properties on the second query to show All records from Table A (Main Data Table) and only those records from Table B (Table created in Query1) where the joined fields are equal.

Then if you are selecting on the VENDOR CODE, bring in the Vendor Code from Table B and in the Criteria put in IS NULL

This will then bring in all records except for the 4 Vendors in Table B.

Hope this makes sense.

 

[Carly]

Thanks for that...I knew I'd done this somehow before but couldn't remember how