Performing query

[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

 

[frank stone]

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.