Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Month and Year display

Status
Not open for further replies.

MPH03

MIS
Oct 18, 2003
13
US
i want to displaly the month and year in the following format
November, 2003 on a report header...what expression would I use for this ? I have tried to use many "versions" of the date expression but no luck !! thanks for the continued help...it is truly a great forum !
~MPH03
 
If you want today's month and year:
=Format(Date(),"mmmm, yyyy")

Duane
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top