Merging to table into one

  • Thread starter Thread starter Jason frazer
  • Start date Start date
J

Jason frazer

I have two tables that are the same except for 3 thing.
Table #2 has different data in three fields than Table #1.
There is about 75 fields in each table. The tables have
all the same field names. I want to replace the data in
three fields ("Actue Toxicity" "Irritation" "other Acute")
with the data in three field ("Actue
Toxicity" "Irritation" "other Acute") in Table #2 and save
this as a table #3 not a query.

Thanks for your help
 
Create a query linking the wanted data and then change
the query type to MAKE TABLE.
This should create the third table as you want it.

good luck,
 
Back
Top