Calculate cost in access database

Closed
Ryan - 10 May 2010 à 07:39
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 10 May 2010 à 08:06
Hello

I am trying to calculate the total cost of time and labor when a quality report is written. My database has a subform which gets updated periodiclally with the date, technician name, and action performed. I've calculated that the cost for time and labor every time an action is performed is approx. $7.00. What I want to do is add a field in the database which will keep a running track of the cost every time an action is added to the sub form, based on the technician name (which will allow me to modify the costing later). I am having a very hard time figuring out the formula to use, and how to link my field to the sub form/technician field.

Any help would be greatly appreciated, since I am newer to advanced use of access.

Thank you!

-Ryan Wagner

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
10 May 2010 à 08:06
hard to tell you without looking at the DB. However one option could be that you have another table that keeps that running total. The other option is that since information is already in DB, all you would need is a appropriate query to add up.