HELP! with Unmatched

[Beagle1927]

Hello I have a question concerning unmatched queries. I have two
tables. There is no unique identifier. I quess the whole row can be
considered a unique identifier. I want to pull out the data from one
table that does not match the data in the other table. There are some
50 or so rows and when I try outer joins it give me an amibiguus outer
join error.

 

[Steve]

First you have to create a Primary Key in each table. You then link the
primary keys in the unmatched query.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)