Display common values query

[access09]

I am trying to run a query to display all the account numbers that appear in TableA but do not appear in TableB. What should i type into the criteria section? I tried 'not equal' but just returns a list of the account numbers in both tables.

 

[DCrake]

You need to use the Unmatched query wizard to get what you want

 

[access09]

Thanks. How do I do that? I don't see that option in the wizard.

 

[DCrake]

What version of Access are you using?

 

[access09]

access 2003

 

[DCrake]

Ok

Click on the Queries Tab then select New. A list box will appear, at the bottom is a wizard "Find Unmatched Query Wizard" Select this and proceed through the steps to create your query.

David