Returning the previous month form the control source property of a text box (1 Viewer)

[Carl_R]

I Have a simple report that is based on a query. The report is always run on the first of a month and displays data from the previous month.

I know that

=Format(Date(),"mmmm")

in the control source property of a text box will return the current Month in letters (example: July).

Is there a simple way to show the previous month?

 

[Mike375]

Try this in unbound text box

=MonthName(Month(Date())-1)

 

[Carl_R]

Thanks Mike.