Simple query - compare 2 fields

[sysr]

I have Table A with a field called Badge_Number

I have Table B with a field called Badge_Number

Table A with field Badge_Number has entries 101, 102, 103, 104, 105

Table B with field Badge_Number has entries 103, 104

I need to do a query that gives the results of entries in A that are not in B
(101, 102, 105)

This is the only thing that I have to do in Access. I have tried to learn as
much as possible, but I am running out of time. Any help would be greatly
appreciated.

Thanks.

 

[Allen Browne]

When you click the Queries tab of the Database window, and click New, Access
offers you several wizards. One of them is the Unmatched Query Wizard.

 

[Tom Ellison]

Dear sysr:

SELECT [Table A].*
FROM [Table A]
LEFT JOIN [Table B]
WHERE [Table B].Badge_Number IS NULL

Tom Ellison

 

[sysr]

Thank you very much, it worked perfectly!