Show records that are not in a table

[Duncs]

OK, I'm probably being dumb about this, but I can't work it out!

I have two tables, both of which contain the same fields but different
data.

What I have is the following:

Table1 has 1500 records in it
Table2 has 750 records in it

What I want to do, is create a new table that contains the 750 records
that are in Table1, which do not match the records in Table2.

As I say, it sounds simple and I’m probably being stoopid about this,
but I just can’t figure it out. Can someone help?

TIA

Duncs

 

[Allen Browne]

When you create a new query, the first dialog has a choice called:
Unmatched Query Wizard.

Put this guy to work for you.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

OK, I'm probably being dumb about this, but I can't work it out!

I have two tables, both of which contain the same fields but different
data.

What I have is the following:

Table1 has 1500 records in it
Table2 has 750 records in it

What I want to do, is create a new table that contains the 750 records
that are in Table1, which do not match the records in Table2.

As I say, it sounds simple and I’m probably being stoopid about this,
but I just can’t figure it out. Can someone help?

TIA

Duncs

 

[Fred]

First you'll have to define for your self what you mean by "same record" 1.
Do you just mean that they contain the same basic entities (I.E. if it's a
list of people, then that they are the same people? And, if so, you need to
define an exact definition of "same record". If one table has James P.
O'Hara and the other has James P. O' Hara (with a space after the" ' ",
should it just call that a non-match, or be brought up for manual review?

2. Or do you mean that every detail of every record matches? If this data
has been entered independently, then your number of "same records" matches in
this respect will probably be about zero.

You were probably thinking #2, but in reality need something like #1 I
would recommend deciding on those specifics, and then responding or
re-posting with those specifics.

 

[Duncs]

Cheers Allen.

Told you I was having a Blonde moment...no disrespect to any blondes
here!

Duncs