J
Jean-Marie
I am building a database to manage a fleet of transport
vehicles. My system is Access 2000/Win XP Pro.
I have among other tables
- tblVehicles (LicensePlate (PK), ChassisNo, AcqDate,
HorsePower, MotorType),
- tblRevenue (IDRevenue, DateRev, AmountRev, VehicleRev,
DriverRev, CommentRev).
I have built a query that displays the summary revenue
per week for a given vehicle, something looking like this.
----------------------------------
Week # Revenue
Week1 Rev1
Week2 Rev2
..... ....
Weekn Revn
-----------------------------------
Now I need to build another one that gives the cumulative
revenue per week, something like the following
--------------------------------------------
Week # Revenue
Week1 Rev1
Week2 Rev1+Rev2
..... ....
Weekn Rev1+Rev2+ . +Revn
-------------------------------------------------
I don't know how to get there. Can someone help me,
please?
Tanks in advance and Merry Christmas
Jean-Marie.
vehicles. My system is Access 2000/Win XP Pro.
I have among other tables
- tblVehicles (LicensePlate (PK), ChassisNo, AcqDate,
HorsePower, MotorType),
- tblRevenue (IDRevenue, DateRev, AmountRev, VehicleRev,
DriverRev, CommentRev).
I have built a query that displays the summary revenue
per week for a given vehicle, something looking like this.
----------------------------------
Week # Revenue
Week1 Rev1
Week2 Rev2
..... ....
Weekn Revn
-----------------------------------
Now I need to build another one that gives the cumulative
revenue per week, something like the following
--------------------------------------------
Week # Revenue
Week1 Rev1
Week2 Rev1+Rev2
..... ....
Weekn Rev1+Rev2+ . +Revn
-------------------------------------------------
I don't know how to get there. Can someone help me,
please?
Tanks in advance and Merry Christmas
Jean-Marie.