Dispay next month month

[Simon]

On a report i would like to dispay next month month

For example it its 29th Nov 2007 i would like to dispaly December 2007

and for 5 December 2007 i would like to dispay January 2008


Thanks

Simon

 

[Jeff Boyce]

Simon

One approach would be to use the DateSerial() function to get to "next
month", and the Format() function to display a date in next month as MMMM,
YYYY.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lance]

MonthName(Month(DateAdd("m", 1, Date))) & " " & Year(DateAdd("m", 1, Date))

 

[Douglas J. Steele]

Or, more simply,

Format(DateAdd("m", 1, Date), "mmmm yyyy")

or

Format(DateSerial(Year(Date), Month(Date)+1, 1), "mmmm yyyy")

 

[John W. Vinson]

On a report i would like to dispay next month month

For example it its 29th Nov 2007 i would like to dispaly December 2007

and for 5 December 2007 i would like to dispay January 2008

=Format(DateAdd("m", Date()), "mmmm yyyy")

as the control source of a textbox will do so nicely.

John W. Vinson [MVP]