query

[Guest]

I have 2 tables A and B with Customer ID as a common
field. A has 10 records of which 5 are common to B too.
I would like to see the records from A that are not in B.

Thanks

 

[fredg]

I have 2 tables A and B with Customer ID as a common
field. A has 10 records of which 5 are common to B too.
I would like to see the records from A that are not in B.

Thanks

Create a New Query.
Select the "Find unmatched Query Wizard" from the opening dialog box.