Query to return all records not selected by intial join

[VE Kiwi]

Hi - This has probably been answered a plenty of times before, but I can't
seem to track down a thread to answer it :-(

I have a table containing customers who may have a Branch Cash Account
assigned to them i.e. they are deemed too small to create a specific Customer
account, plus the 'full' Customer accounts (approx. 66K records). I have a
second table with the list of Branch Cash Accounts (about 80 records), plus a
Cah Account indicator (a 'X'). My query returns all accounts that are Cash
Accounts (approx. 39K records), but I want to be able to also run the (a)
query to return the 27K odd records that are 'proper' customers.

Apologies if the question is a 'brain dead' one, but I'm stumped...

Cheers!

 

[John W. Vinson]

Hi - This has probably been answered a plenty of times before, but I can't
seem to track down a thread to answer it :-(

I have a table containing customers who may have a Branch Cash Account
assigned to them i.e. they are deemed too small to create a specific Customer
account, plus the 'full' Customer accounts (approx. 66K records). I have a
second table with the list of Branch Cash Accounts (about 80 records), plus a
Cah Account indicator (a 'X'). My query returns all accounts that are Cash
Accounts (approx. 39K records), but I want to be able to also run the (a)
query to return the 27K odd records that are 'proper' customers.

Apologies if the question is a 'brain dead' one, but I'm stumped...

Cheers!

The "Unmatched Query Wizard" in the New Query screen will do this for you.

 

[VE Kiwi]

Thx John - Forgot to add that on the Standard Client installed at the client
site, this Feature hasn't been nstalled on the Access version they are
running... why?? Who knows...

Is there something I can include in the Query design that will perform the
same function?

Thx

Paul...

 

[John W. Vinson]

Thx John - Forgot to add that on the Standard Client installed at the client
site, this Feature hasn't been nstalled on the Access version they are
running... why?? Who knows...

Is there something I can include in the Query design that will perform the
same function?

I expect so but I think I don't understand your logic. Your numbers aren't
adding up for me! You have 66k "accounts" records... and then 80 (not k, just
80) cash accounts? Where do the 39K records come from?

What is the actual structure of your table; how is a "proper" record
distinguished from a "cash account" record? Perhaps you could open the query
in SQL view and post the SQL text here.