Updating records

[nickysquawkes]

I have a database with details about employees in it.

There is a field with yearly salary in it and another with an ID number. Recently these slaaries have been increased by a non-standard amount. I have another table with the emplyee ID number and their new salary. I need to update the slaary figure in the first table with the salary figure in the second table. Is there anyway of doing this?

Any help would be most appreciated

Nick

 

[MStef]

Hello Nick!

Try with UPDATE Query.

 

[nickysquawkes]

I have already tried that. The problem with an udpate query is that you can only do blocks of items. E.G. People named "smith" change their pay to XXX. We have 900 people each with an id number and each with a different salary. If that makes sense.

Unless I'm missing something?

 

[MStef]

Newer mind, link two tables via ID number, it must work.
Before make a copy of your first table.