combining tables

[Rachel]

I have two tables with identical headings but different
data and I wanted to combine the two into one table that
includes all of the data. Is this possible? If so, how?
Help! Any help would be appreciated! Thank you so much.

 

[kripesh]

try the forrl article:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;306093

If your table has a autonumber field, this wont work.
there is an alternate solution for that case