I need to change an hourly rate I've been using in Access.

[Guest]

I'm very new to Access. I'm using it to track employee hours and dollars
charged per employee on various projects within a construction company (use
for internal reports only). Database goes back to 2004. I now need to
change the hourly rate for each employee starting with April 07. I only want
the change to take effect going forward, not change the hourly rate which was
in the database going back. Anyone know who to do this without effecting
changing past information? Thank you.

 

[Keith Wilby]

I'm very new to Access. I'm using it to track employee hours and dollars
charged per employee on various projects within a construction company
(use
for internal reports only). Database goes back to 2004. I now need to
change the hourly rate for each employee starting with April 07. I only
want
the change to take effect going forward, not change the hourly rate which
was
in the database going back. Anyone know who to do this without effecting
changing past information? Thank you.

It depends how hourly rate is stored. If it's in a lookup table included in
your main query then it will affect all records. If it's in a lookup table
which is used to copy the hourly rate to the main table then you should be
OK. More info required on your schema.

Regards,
Keith.
www.keithwilby.com

 

[Alex Dybenko]

Hi,
you can either store hourly rate together with hours, so for each record you
have rate and number of hours, or make a table to store rate and effective
date, and use this date in your calculations
to update rate for old records you can use update query

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com