Jump to content

Static Calculations


This topic is 8486 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I was wondering if you can do a calculation and after the calculation is performed it stays unique to that DB.

Example:

I have an employee database which has a "hourly rate" field.

I also have a timesheet DB that looks at the employee "hourly rate" and calculates the hours work times the rate.

If months later I want to increase the hourly rate I do not want it to affect any previous timesheets, just the new records.

Any help is appreciated:

Dave

Link to comment
Share on other sites

A couple of solutions come to mind.

The simplest is to create a related file that contains employee names and hourly rates. Then, have the "hourly rate" field in the main database perform a lookup. That way, the hourly rate for each individual timesheet will be whatever it was at that time, unaffected by changes in that employee's rate.

Link to comment
Share on other sites

This topic is 8486 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.