Problem with query results

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
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.
 
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]
 
You must log in or register to reply here.

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

Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
Queries with Linked Tables 5
Query Returning Multiple Results 1
EMERGENCY! How can I update one table from another in a select que 5
Comparing two tables in Access to look for discrepancies 0
Query that will look for duplicate in two tables. 3
Quering between 2 large tables involving wildcards 2
Comparing Query Results 2

Back
Top