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 - 09 Apr 2005 13:17 GMT
> 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
[quoted text clipped - 7 lines]
>
> 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?

Signature
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
taylormade - 11 Apr 2005 05:49 GMT
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.
> 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
[quoted text clipped - 7 lines]
>
> Kenard