expression for month year

[Guest]

hello all,

i need to have an expression that will need to populate the month & year in
the footer section of my report. for example November 2005. any help would be
appreciated.
thanks

 

[tina]

well, you're giving us very little to go on. but assuming that you want to
pull the month/year from a date field in the RecordSource of your report,
and show it in a textbox control, you can set the Format property of the
textbox control, as

mmmm yyyy

hth