Calculate Payroll in Order Database

[EliteDesk@aol.com]

I have an order database Access 2000 for an inspection company, tblInspectors, tblOrders, tblCustomers, I want to be able to calculate inspector pay within order database. Each inspector is an independent contractor, so it just needs to calculate percentage, for each inspection performed and total for pay period. Each inspector is paid a different percentage, which is stored in tblInspectors. Payroll is paid every two weeks . . . I've been trying to figure out the best way to do this ... Any advise be greatly appreciated.

 

[pbaldy]

Sounds like a fairly simple "totals" query on the orders table, grouped by inspector and summing the amount field, with a join on the inspector table to get the percentage, and multiply the 2. Plus a criteria to restrict it to the appropriate date range of course.

 

[EliteDesk@aol.com]

You make it sound so easy ... Would you store the totals? Should the payroll start and end dates be stored in a table, or just calculated? Thanks in advance for your help?

 

[pbaldy]

I got a few applications where daily data is entered for employees, and payroll is calculated from that. In my case, the employees are drivers of limousines taxis and buses, and they get paid varying percentages of their activity. I push the final payroll amounts into a third party payroll program, so that data is stored there. I do not store the totals or dates. The user inputs the date range they want to pay on a form, and the various process look there for them.

 

[EliteDesk@aol.com]

pbaldy, thanks for the advise, I appreciate you taking the time to reply!