Working with tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,
I have two tables customer1 and customer2, I want to know how many customer
from customer1 there aren't in customer2.

Thanks
 
Why do you have two tables like this? It sounds like you might not be
following normalized database design. What differentiates a person in one
table from the other? Probably (but not 100%) you should have all of these
folks in one table and a new field to differentiate them.

Post back more details and we can help you normalize your data and save you
a lot of heartache down the road.

If you are not interested in normalizing and simply want an answer to your
question, you can create an UNMATCHED query to find all records in one table
that are not in the other. The query wizard offers this option and will
walk you right through building it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple sources for a listbox or combo-box 2
sum with multiple criteria 4
matching a customer with a twist.. 1
update query with summary 2
Search for a value that repeats several times in another table 3
Multiple values to link to other tables 2
Database summary 4
Max date 3

Back
Top