Performing query

  • Thread starter Thread starter CT
  • Start date Start date
C

CT

I want to perform a query that will look at one table,
tell me what products are in that table, and then tell me
what products are not in that table (based on a complete
listing in another table). How do I do this? What
formula do I use and where do I use it? Thanks.

CT
 
sounds like you need to create an unmatched query. there
is a whizard available to do that when you click the new
query button. this will return a list of what is not in
the table. then do a simple select query to get what is in
the table.
 
Back
Top