G
Guest
Man why is it that managers want to see such hard to gather information?!
OK!I have a query that is set up to gather information from a table,
basically a weeks woth of totalizer readings, in gallons. it looks like this:
Maintenance Date Air Stripper 101.Stripper Totalizer Reading
4/8/2006 370352300
4/9/2006 370840100
4/10/2006 371332100
4/11/2006 372432100
4/12/2006 373109400
4/13/2006 373857200
4/14/2006 374762500
The number represent gallons, my boss wants to know how many gallons per
day, not the reading.
Is there a way either within the query or on the report to calculate the
gallons per day based on the reading of the two days?
OK!I have a query that is set up to gather information from a table,
basically a weeks woth of totalizer readings, in gallons. it looks like this:
Maintenance Date Air Stripper 101.Stripper Totalizer Reading
4/8/2006 370352300
4/9/2006 370840100
4/10/2006 371332100
4/11/2006 372432100
4/12/2006 373109400
4/13/2006 373857200
4/14/2006 374762500
The number represent gallons, my boss wants to know how many gallons per
day, not the reading.
Is there a way either within the query or on the report to calculate the
gallons per day based on the reading of the two days?