Re: Selecting Records from a previous Month

-----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