Move back a month

[Lime]

I a query I have an experssion Field: Month: Month(Data() and it populates
the table with four... Thats good, but I need it to display March. Alway
going back a month as this is when the data was pulled. Any hints?

 

[akphidelt]

Just add a - 1 to the end of it.

Month: Month(Date())-1

 

[Klatuu]

Three problems,
1. Never use an Access reserved word as a name.
2. The OP wants 15 days, not a month
3. That will do no filtering as written

 

[John W. Vinson/MVP]

I a query I have an experssion Field: Month: Month(Data() and it populates
the table with four... Thats good, but I need it to display March. Alway
going back a month as this is when the data was pulled. Any hints?

\Don't use the reserved word Month as a fieldname, for starters. If you want
to display the text string "March" for any date in April, or "December" for
any date in January, use

ShowMonth: Format(DateAdd("m", -1, Date()), "mmmm")

 

[Lime]

Hello,
Thank you... Very Helpful.

\Don't use the reserved word Month as a fieldname, for starters. If you want
to display the text string "March" for any date in April, or "December" for
any date in January, use

ShowMonth: Format(DateAdd("m", -1, Date()), "mmmm")