Comparing two tables

N

newbie help

Hi,
I'm new and feel like there has to be a simple solution to my problem:

I am looking to take two tables in Access and pull out data from one
table that does NOT have a match in the other. One table contains our
existing accounts and the other contains our new and existing. I need
to be able to pull the new ones out.

Any help with this would be greatly appreciated!!!

thanks!!!
 
G

gls858

newbie said:
Hi,
I'm new and feel like there has to be a simple solution to my problem:

I am looking to take two tables in Access and pull out data from one
table that does NOT have a match in the other. One table contains our
existing accounts and the other contains our new and existing. I need
to be able to pull the new ones out.

Any help with this would be greatly appreciated!!!

thanks!!!
Click to expand...
Create a Find Unmatched Query. In the objects select Queries then hit the
new button and select unmatched query. Follow the prompts. If you need more
help post back.

gls858
 
S

sherwin verdun

go to query, create new query, follow the prompt, click find unmatched query,
then, follow the wizard.
 
N

newbie help

Thank you thank you thank you!!! That was so quick and easy!!! Saved
me hours of work!
 
Top