Selecting Records from a previous Month

[Finlay]

Hi Group

I am designing a report that should show a meter reading for each
month and the previous meter reading for the previous month. The
months are text stored in a field tMonth.

The current month is easy to pull out of the data base but I don't
know how to get the previous months meter reading.

The previous reading is subtracted from the current reading to get the
months usage
Please Help

Thanks

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When you say the months are stored as text do you mean the month
number (1-12) or the month name? If the month name what's its format
first 3-letters of month name or complete month name?

You can find out the previous month by using the DateAdd() function.
E.g.:

Last month's number:

month number = Month(DateAdd("m", -1, Date()))

Last month's name:

3-ltr month:
month name = Format(DateAdd("m", -1, Date()), "mmm")

full month name:
month name = Format(DateAdd("m", -1, Date()), "mmmm")

HTH,

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP84s44echKqOuFEgEQLPDACg5OWfsIWmGjTN8He2Q75/286R4+IAoNqa
sWn75XOUBu1My49L95ObolTX
=Yz0T
-----END PGP SIGNATURE-----

Finlay wrote:

Hi Group

I am designing a report that should show a meter reading for each
month and the previous meter reading for the previous month. The
months are text stored in a field tMonth.

The current month is easy to pull out of the data base but I don't
know how to get the previous months meter reading.

The previous reading is subtracted from the current reading to get the
months usage
Please Help

Thanks