Add data to table?

[geralf]

Hi!

I want to update some records in one table from another table. How do I do this?

I see how I can increase a value by 5% by setting the 'Update to' field in an update query to '*1.05', but I want the new value from another table.

Thanks in advance

 

[Ian Mac]

Hello,

In the design view select both tables and Link the fields you need to Update from/to.

In the field put 'YourRequiredField'
In 'The Update To:' you put something like [TableFrom]![YourRequiredField]

This will update TableTo with TableFrom's data.

Hope that makes sense.

Regards.

 

[Superock]

More Info

Would you only need to connect on field from both tables?

 

[geralf]

Yes, only fields from both tables

Thank you both for the replies. I'm not at work now, so I can't try this out till tomorrow.

Thanks again!