Displaying "Current Month" on Report Header

BrianFawcett

Registered User.
Local time
Today, 15:45
Joined
May 3, 2010
Messages
63
I am creating a report and I want the title to be "Sales Adjustments CURRENT MONTH".

Is there a way to this easliy?
 
Presumably you mean with the actual month displayed? Try a textbox:

="Sales Adjustments " & Format(Date(), "mmmm")
 
Can I add year by adding "yyyy" to the textbox?
 
Look in help at the Format() function. You can customize it pretty much any way you want, or you can concatenate the year on separately.
 

Users who are viewing this thread

Back
Top Bottom