Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / April 2005

Tip: Looking for answers? Try searching our database.

Calculation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kenard - 09 Apr 2005 13:01 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 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.