Display previous month on report

[ryangus]

I simply wish to place the name of the last month (prior to the current
month) on a report.

I've tried using =Month(now())-1, which returns the numerical value as
10, but I cannot get it to display as October.

Any ideas?

[tina]

try

=Choose(Month(Date())-1), "January", "February", "March", "April", "May",
"June", "July", "August", "September", "October", "November", "December")

the above goes all on one line in the textbox control's ControlSource
property, of course. suggest you read up on the Choose() function in Access
Help, so you'll understand how it works.

hth
<ry*****@gmail.comwrote in message
news:11**********************@h54g2000cwb.googlegr oups.com...

I simply wish to place the name of the last month (prior to the current
month) on a report.

I've tried using =Month(now())-1, which returns the numerical value as
10, but I cannot get it to display as October.

Any ideas?

[ryangus]

Cheers - one minute before reading your reply, I found this to work:

=Format$(DateAdd("m",-1,Now()),"mmmm")

Not sure which version is more eloquent, however it's nice to have too
many options than not enough!

Thanks,
Ranga
tina wrote:

try

=Choose(Month(Date())-1), "January", "February", "March", "April", "May",
"June", "July", "August", "September", "October", "November", "December")

the above goes all on one line in the textbox control's ControlSource
property, of course. suggest you read up on the Choose() function in Access
Help, so you'll understand how it works.

hth
<ry*****@gmail.comwrote in message
news:11**********************@h54g2000cwb.googlegr oups.com...

I simply wish to place the name of the last month (prior to the current
month) on a report.

I've tried using =Month(now())-1, which returns the numerical value as
10, but I cannot get it to display as October.

Any ideas?

[tina]

yep, that'll do it. very good :)
<ry*****@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...

Cheers - one minute before reading your reply, I found this to work:

=Format$(DateAdd("m",-1,Now()),"mmmm")

Not sure which version is more eloquent, however it's nice to have too
many options than not enough!

Thanks,
Ranga
tina wrote:

try

=Choose(Month(Date())-1), "January", "February", "March", "April",

"May",

"June", "July", "August", "September", "October", "November",

"December")

the above goes all on one line in the textbox control's ControlSource
property, of course. suggest you read up on the Choose() function in

Access

Help, so you'll understand how it works.

hth
<ry*****@gmail.comwrote in message
news:11**********************@h54g2000cwb.googlegr oups.com...

I simply wish to place the name of the last month (prior to the

current

month) on a report.
>
I've tried using =Month(now())-1, which returns the numerical value as
10, but I cannot get it to display as October.
>
Any ideas?
>