Table1.RecNum not equal to Table2.Recnum 1

[Rich24]

Hi all,

I think this is easy, but I'm real rusty on my Access. I'm trying to create a Query to display records that do not match RecNum from Table1 to RecNum in Table2. Thanks!

 

[Golom]

This gives you the "RecNum" values in Table1 that do not exist in Table2.

Select T1.RecNum

From Table1 T1 LEFT JOIN Table2 T2
     ON T1.RecNum = T2.RecNum

Where T2.RecNum IS NULL

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[Rich24]

Thanks Golom! That worked just fine.