Update Query Problem

[Guest]

Hi--I am trying to figure out how to give a raise to a select number of
people in my query. I have it set up by social security number and wage
rate, what I am having problems with is the people are not getting the same
amount of raise and I cannot make it work so only the right people get their
raise....

I have set up a new table with the SSN's and Raise increase, what Im trying
to do is add the raise to the rate...any ideas?

 

[John W. Vinson]

Hi--I am trying to figure out how to give a raise to a select number of
people in my query. I have it set up by social security number and wage
rate, what I am having problems with is the people are not getting the same
amount of raise and I cannot make it work so only the right people get their
raise....

I have set up a new table with the SSN's and Raise increase, what Im trying
to do is add the raise to the rate...any ideas?

the SSN should be the Primary Key of both tables, I'm guessing. Create a Query
joining the two tables by SSN; update the wages table Wage field to

[Wages].[WageRate] + [Raises].[RaiseAmount]

or whatever the table and fieldnames are. The brackets are essential,
otherwise Access will interpret the names as text strings.

John W. Vinson [MVP]