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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to Populate Data from a table to another 0
VBA - retrieve data on last create named range from previous inserted named range 0
New record added when debugging but not when running normally 2
operation must use an updatable query 3
Create Table from a Form 1
Access Sorting and grouping using multiple tables 0

Back
Top