I need the quickest way to compare to table, and add additional.  Can anyone help?

Delores_C
Delores_C used Ask the Experts™
on
I need the quickest way to compare to table, and add additional.  Can anyone help?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:
Compare what? Add what?

Are you asking about data or the design?


Author

Commented:
Data in Access 2007
Top Expert 2010

Commented:
Delores_C,

Your question is very vague.  Please try to add some detail describing precisely what it is you need to do.

An example would be most helpful :)

Patrick
Top Expert 2011
Commented:
Based on your very general/vague description I can only  guess at what you might need.

My first though is an update query.  You can include the two tables. Join on the primary key. Compare fields. Update fields from one table to another.


That is the best I can do without specific detail on exactly what you want to do.

Boyd aka HiTechCoach
Microsoft MVP - Access Expert
http://www.hitechcoach.com

Author

Commented:
There was a find unmatch query, which provided what I needed.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial