New Project -- can use some help

[djclntn]

I was given a new project which I can use some help. It’s a database which contains 50+ Employees &Records are kept containing the ‘Dates’ employees worked & the ‘Hrs.’ Their salaries/pay is of course calculated accordingto ‘Hrs’ worked, but the problem is I need to give many employees an increasein their salaries by i.e. 6/1/2013. I knowI can’t just go in & change/update employees’ salaries because that willchange ALL of the employees’ salaries proceeding 6/1/2013. I’m not sure if this requires an Append Queryor an Update query. I hope that some canunderstand my question; it may be hazy?



Thanks in advance.

[rzw0wr]

I have read of this type of problem on several forums.

You may want to google allen brown, brown may be spelled browne.

Dale

[pbaldy]

It would help to know your table structure. I would either have a history of transactions that wouldn't be affected by changes to current salary, or a table with salaries and effective dates.

[djclntn]

I don't know if my message got through to you so I'm resending it. I have 1-tbl with just the EmployeesID & Salaries. I have anther tbl which contains EmployeesID, Dates Worked, & Hours Worked. I then a query from these 2-tbls (joined by EmployeesID) where I can calculate monthly sums. Hope this helps & sorry if you get this message twice.

[pbaldy]

I would add a salary amount field to the table with dates and hours. It's no different than storing the price a product was sold for with the sale record.

[orange]

Dave,

I've been busy and haven't had much time with Access. I agree with Paul (Baldy) that a little more detail of your set up would be good. And as he says a table of Employee Salaries with effective Dates makes sense.
You don't want to record Salary in the Employee table --since any historical reports, queries etc would use that salary value and not one from the proper time period-- so store the "salary at the time of the "occurrence/incident" so the correct salary is used in the calculation.