update table using data from another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have tried to use a query to transfer data from one table to another by
using the Update to query howevever the information doesn't transfer to the
other table. I have also link the feilds to each other.

Can someone please help me iin advising what I am missing here.

Thanks
Noemi
 
An Update query will change the values of fields in existing records to the
new value. If you are wanting to add records to the second table, try an
Append query instead.
 
Hi Wayne
Thanks for the suggestion however I tried it and it still will not update
the other table.

Any other suggestions.

Thanks
Noemi
 
Back
Top