Meter Reading

message from Bob Martin on 20 May 2004

I need to prepare monthly usage reports for 200+ turnouts
off our canal. Each turnout has a meter. Each meter is
read every week plus on the last day of the month. The
monthly report needs to show the beginning of month meter
reading, the end of month meter reading and the
difference in the meter readings.

Sample data from the MeterReadings Table is as follows:

DateRead Milepost Meter_Reading
3/5/2004 10.5 100
3/5/2004 12.0 555
3/12/2004 10.5 110
3/12/2004 12.0 575
3/19/2004 10.5 125
3/19/2004 12.0 600
3/26/2004 10.5 130
3/26/2004 12.0 625
3/31/2004 10.5 140
3/31/2004 12.0 650
4/2/2004 10.5 155
4/2/2004 12.0 675
4/9/2004 10.5 175
4/9/2004 12.0 700
4/16/2004 10.5 180
4/16/2004 12.0 725
4/23/2004 10.5 185
4/23/2004 12.0 750
4/30/2004 10.5 195
4/30/2004 12.0 775
5/7/2004 10.5 205
5/7/2004 12.0 800
5/14/2004 10.5 215
5/14/2004 12.0 825

Here's my dilemma: I am having difficulty with figuring
out how to display the meter_reading for the beginning of
the month (which is actually the end of the previous
month meter_reading) in my report. I am able to represent
all the other necessary info. Any suggestions?

M.L. Sco Scofield replied to Bob Martin on 21 May 2004

For speed, I use VBA code to do this.

For a non-code approach, which although slow, does work, see http://support.microsoft.com/default.aspx?scid=kb;en-us;208714.

Good luck.

Bob replied to M.L. Sco Scofield on 24 May 2004

Thanks for pointing me in the right direction!!

see http://support.microsoft.com/default.aspx?scid=kb;en-
us;208714.
diagram
in message news:fc2101c43e86$360a9720$a301280a@phx.gbl...
turnouts
is
The
meter
follows:
figuring
represent

Archived message: Meter Reading (Microsoft Access Database)