Deleting Records! 1

[Smitty020]

OK, I have two tables. One has InvoiceNums, Amount, Date, ect... The second table also has InvoiceNums, Amount..and a few other attributes! I want to see all of the records from the first table where there isn't a matching InvoiceNum in the second table! I've tried delete queries, setting criteria in queries, but I just can't figure out exacrly how to do it! I've been away from Access for a while, so I'm a little rusty! Can anyone please help???

Thanks,
Smitty

 

[AccessSQLUser]

SELECT Table1.InvoiceNum, Table1.Amount, Table1.Date
FROM Table1 LEFT JOIN Table2 ON Table1.InvoiceNum = Table2.InvoiceNum
WHERE Table2.InvoiceNum Is Null

 

[Smitty020]

Thanks for the help! I can't believe I was going about it the wrong way! It's been a long morning!

Smitty