Thread: Combine tables
View Single Post
  #2  
Old August 17th, 2007, 02:20 PM posted to microsoft.public.access
scubadiver
external usenet poster
 
Posts: 1,673
Default Combine tables


use an append query but make sure you have a unique identifier for each row

--

The 11th day of every month:

http://truthaction.org/forum/index.php


"Rose" wrote:

I have two tables that are identical except they contain differant records.
What is the easiest way to combine them into one?
--
Rose