Hi Experts ,
Have been trying to find a solution to a problem and cant seem to solve it please help.
I have a sheet that captures repairs done to a vehicle at different times. The unique id is VehicleId and the fields for repairs are Repair1, Repair2,Repair3,Repair4,Repair5 Total Repair.
I am capturing the vehicle repair info from a vba userform and the entry is made after the vehicle id is entered and the new repair data is added each on new line in the worksheet, meaning that if for ex there are say 3 repairs done for vehicle id no 100 then it would look as follows:
Date of Repair Vehicle Id Repair1 Repair2 Repair3 Repair4 Repair5 Total Repair.
01/05/2013 1001 1500 0 0 0 0 1500
02/06/2013 5002 750 0 0 0 0 750
02/07/2013 1001 1500 3000 0 0 0 4500
04/08/2013 5002 750 350 0 0 0 1100
On the report user form when the user enters the Vehicle Id i would like the textbox that is on the userform that says Total Repairs to display the sum total of all repairs done for that vehicle.
Ex:- if the user enters 1001 Total Repairs should display 4500
PS( i do not necessarily need the total repairs on the sheet if the calculation could be directly done on the userform at the time of query is also fine i guess)
Have tried my head around it but cannot seem to do it .... Pleasse hellllp
Naz.
Bookmarks