Easy question - compare 2 fields

[sysr]

I have a field called Badge_Number in Table A.

I have a field called Badge_Number in Table B.

In Table A Badge_Number has entries 101, 102, 103, 104, 105

In Table B Badge_Number has entries 102, 103

How can I do a query to get a list of entries that are in A but that are not in B. (Query result would be 101, 104, 105)


This is the only thing I have to do in Access, so after trying to learn this for a while, I have decided it would be much easier to get help at this time. Any help is greatly appreciated.

Thanks,
Scott

 

[MStef]

Hello Scott!

Let wizard to make a query.
In your App window click on Queries, New, Find Unmatched Querey Wizard, follow wizard.

 

[kingsgambit]

Select new query
Run unmatched query wizard