Simple query - compare 2 fields

  • Thread starter Thread starter sysr
  • Start date Start date
S

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.
 
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.
 
Dear sysr:

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

Tom Ellison
 
Back
Top