Display no-match between tables

[Guest]

Access 2003

I have a table with the fields: LC, LC Name where LC is the code for a
facility and LC Name is the Name of the facility

I have a second table that in imported from an external database with the
fields LC, LC Data where LC Data is financial information.

The two tables are joined by LC. I need to verify table 1 has up to date
information based on the LC records found in table 2.

I have a simple query with both tables in the query and LC as the field.
The data returned is all LC records that match in both tables. How do i
change this to show all LC records that are in table 2 but NOT in table 1?

Appreciate any help you can provide.

 

[Guest]

In the query design view, right click on the line that joins the LC fields
from the two tables and click on 'join properties'. Select the option that
best suits the outcome you want.

Delordson Kallon
http://www.instantsoftwaretraining.com/

 

[Guest]

Hang on. I think I may have been too hasty there. The best method is to use
the "find unmatched query wizard" which is one of the options when creating a
new query.

Delordson Kallon

 

[Guest]

Thank you, sometimes things can be so easy, and right under your nose.

For anyone that might need more information on this. To get to the find
unmatched query wizard click on the 'New' icon which is located next to
'Open' and 'Design' options while on the query screen.

Course if that is more confusing i apologize.