Comparing two tables

  • Thread starter Thread starter newbie help
  • Start date Start date
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!!!
 
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
 
go to query, create new query, follow the prompt, click find unmatched query,
then, follow the wizard.
 
Thank you thank you thank you!!! That was so quick and easy!!! Saved
me hours of work!
 
Back
Top