Rose,
Create an Append Query to add the records from one table into the other.
Make sure you backup both original tables before doing the Append.
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love, and you'll never work a day in your life."
"Rose" wrote in message
news
I have two tables that are identical except they contain differant records.
What is the easiest way to combine them into one?
--
Rose