Mark Liddle
Registered User.
- Local time
- Today, 13:29
- Joined
- Sep 12, 2000
- Messages
- 13
Hi All
I have a database that records the Maintenance & Repair costs for vehicles, per Department.
I have got the report to give me the usual summary details as follows.
Department 1
Vehicle Name1
Repair Item 1 Cost1 Labour1
Repair Item 2 Cost2 Labour2
Total Cost 1+2 Lab1+2
Ave Ave(Cost1+2) Ave(Lab1+2)
Vehicle Name2
Repair Item 3 Cost3 Labour3
Repair Item 4 Cost4 Labour4
Repair Item 5 Cost5 Labour5
Total Cost 3+4+5 Lab3+4+5
Ave Ave(Cost3+4+5) Ave(Lab3+4+5)
Summary
Total Cost(1 to 5) Lab(1 to 5)
Ave Cost(1 to 5) Lab(1 to 5)
My problem is that the above summary only give the SUM and AVG for each department.
I want to calculate additional Total and Average costs for the company as a whole,
in the same report
I.E.
1. Dept/Vehicle Average = sum of all costs accrued to that Dept / number of vehicles in the Dept.
2. Department Ave = sum of ALL costs / number of depts
This obviously requires that somehow I count the number of vehicles and departments and build it into the calculation on the report. But how ??
Thanks for your assistance.
I have a database that records the Maintenance & Repair costs for vehicles, per Department.
I have got the report to give me the usual summary details as follows.
Department 1
Vehicle Name1
Repair Item 1 Cost1 Labour1
Repair Item 2 Cost2 Labour2
Total Cost 1+2 Lab1+2
Ave Ave(Cost1+2) Ave(Lab1+2)
Vehicle Name2
Repair Item 3 Cost3 Labour3
Repair Item 4 Cost4 Labour4
Repair Item 5 Cost5 Labour5
Total Cost 3+4+5 Lab3+4+5
Ave Ave(Cost3+4+5) Ave(Lab3+4+5)
Summary
Total Cost(1 to 5) Lab(1 to 5)
Ave Cost(1 to 5) Lab(1 to 5)
My problem is that the above summary only give the SUM and AVG for each department.
I want to calculate additional Total and Average costs for the company as a whole,
in the same report
I.E.
1. Dept/Vehicle Average = sum of all costs accrued to that Dept / number of vehicles in the Dept.
2. Department Ave = sum of ALL costs / number of depts
This obviously requires that somehow I count the number of vehicles and departments and build it into the calculation on the report. But how ??
Thanks for your assistance.