Meter Reading

[Bob Martin]

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]

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.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Bob]

Thanks for pointing me in the right direction!!

-----Original Message-----
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.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

"Bob Martin" <[email protected]> wrote

in message news:[email protected]...