H
HotRodSue
I have weights for trucks recorded by date. For each TruckID I need to
average the 3 most recent weights. So, I believe for each truck I need to
query the most recent 3 by date, then sum the most recent 3, and then average
the most recent 3. Just not sure how to accomplish that.
My table:
TruckTareID (Primary Key)
TruckID
TareDate
TareWeight
Since the average weight changes over time, can this be accomplished with
running totals? For instance, I need average weight as of August 1st, and
the average weight as of August 5th, etc.
Any suggestions are appreciated.
average the 3 most recent weights. So, I believe for each truck I need to
query the most recent 3 by date, then sum the most recent 3, and then average
the most recent 3. Just not sure how to accomplish that.
My table:
TruckTareID (Primary Key)
TruckID
TareDate
TareWeight
Since the average weight changes over time, can this be accomplished with
running totals? For instance, I need average weight as of August 1st, and
the average weight as of August 5th, etc.
Any suggestions are appreciated.