Calculation

[Kenard]

I am doin a automitive database, however i am faced with a problem.
Staffs are not paid hourly. So i need to come up witha function that will
enable me to calculate the total charge for each repair order. the only
fields I have r :
WorkorderID------------Repair Order-------------Cost
How can I create a formula that will calculate all the labor peformed on the
particular job.

All advice and tips r welcomed.

Kenard

 

[Rick Brandt]

I am doin a automitive database, however i am faced with a problem.
Staffs are not paid hourly. So i need to come up witha function that
will enable me to calculate the total charge for each repair order.
the only fields I have r :
WorkorderID------------Repair Order-------------Cost
How can I create a formula that will calculate all the labor peformed
on the particular job.

All advice and tips r welcomed.

Kenard

It doesn't appear to me that those fields are enough to determine labor. You
say that the staff are not paid hourly so just exactly how do you charge for
labor? In other words, if you had to charge a customer with nothing but a pen
and paper as your tools, what would you do?

 

[taylormade]

A database might not be the best way to do this if you truly only have three
fields. From a business perspective you could charge an hourly rate even if
employees are not paid that way.

If you look at the Northwind database and see how they handle purchase
orders and invoices you could model that concept to do tbl_workorders, and
tbl_repairorders using a transition table to link the two.

To do totals you need to write a query from your tables that sum up the
repairorder totals for a specific customer/job...you could also do this using
the report wizard and experiment with grouping and sums on your cost field.