Merge two tables

[forest8]

Hi there

I inherited information from a colleague who had created 2 tables instead of
one table with all the information.

How do I combine the information from the 2 separate tables into 1?

Essentially the original 2 tables are two different halves of the same
survey, Survey 1 and Survey 2.

Thank you in advance.

 

[John W. Vinson]

Hi there

I inherited information from a colleague who had created 2 tables instead of
one table with all the information.

How do I combine the information from the 2 separate tables into 1?

Essentially the original 2 tables are two different halves of the same
survey, Survey 1 and Survey 2.

Thank you in advance.

Probably an Append Query, but the details will depend on the structure of the
tables. Do they have Autonumber primary keys? If so, it's likely that you have
records in the two tables with duplicate ID's; this can cause hassles if there
are related tables.

Are there related tables? Do you have Autonumbers? More details please!

 

[Gina Whipp]

forest8,

With the limited information you provided I would say use an Append query.
HOWEVER, note the big however, using one table sounds more like a
spreadsheet then a normalized database which is what Access is. Perhaps you
could provide details on your table structure so we may better reply to your
question... Why? Because it might be that you actualy needed 6 tables
instead on trying to turn two tables into one.

To get a better example of what I'm talking about have a look at the table
structure in this database...
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm