Suppress Records From One Table of Two 1

[gizmo1973]

I have two Tables A & B
Table A contains all records of table B and many more
I want to run a query (or whatever solution may suffice)to just give me table A purged of Table B
I would normally do this in MS Excel but the records are 65k +
Access is not my strong point so please be patient and give me step by step ideas if you have any!

Regards, Phil.
C.E.O. Bodgeit, Leggit & Scarper. International.
"Stuffing things up completely since 1973"

 

[Crowley16]

Hey gizmo...

the sql string ur looking for would run along the lines of:

SELECT * FROM tblA WHERE tblA.PKey NOT IN (SELECT tblB.FKey FROM tblB)

tblA.PKey would be linked with tblB.FKey

--------------------
Procrastinate Now!

 

[gizmo1973]

Crowley,

Cheers for that but all I gte is a Syntax Error and the WHERE is then highlighted.

HELP!!!

Regards, Phil.
C.E.O. Bodgeit, Leggit & Scarper. International.
"Stuffing things up completely since 1973"

 

[Crowley16]

are you sure you've got the brackets in properly?

add another set to the embedded select...

--------------------
Procrastinate Now!

 

[gizmo1973]

Re typed and double checked and it works fine!!!
Have a *

Regards, Phil.
C.E.O. Bodgeit, Leggit & Scarper. International.
"Stuffing things up completely since 1973"