=monthname(month(now())-1)

[gilinnc]

I get a #Func! error on my today report.

What I am doing is that I am putting the last month name on the top of the report.

Since we jump from 2012 to 2013, I have a feeling that it is the cause and the current 'formula' does not work.

Is there a good way to allways put the last month on top of the report? Yes, this is permanent.

Gil

 

[pr2-eugin]

Try this..

MonthName(IIF(Month(Date)=1,12,Month(Date)-1))

 

[gilinnc]

Thanks, that last one does it. I was not thinking as well as I should.

I figure that if it was January and now()-1 equals to Zero, Access would not think to refer it to December of last year.

I have to redo all my Access stuff to make special consideration on the 'year' change...ugh!

Thank you all for your help and have a great new year!

Gil