Problem with query results

A

Alex Martinez

Hi,

I am using Access 2002 and I have two tables the common link between the
tables are policy numbers. What I want to do is to get a result that only
shows the policy numbers that are not matched from both tables. How do I do
this?. Any tips will be appreciated. Thank you.
 
J

John Vinson

Hi,

I am using Access 2002 and I have two tables the common link between the
tables are policy numbers. What I want to do is to get a result that only
shows the policy numbers that are not matched from both tables. How do I do
this?. Any tips will be appreciated. Thank you.
Click to expand...

Use the "Unmatched Query Wizard" in the New Queries.

John W. Vinson[MVP]
 
Top