Concatenate Expression with text string in Report?

  • Thread starter Thread starter Steve Stad
  • Start date Start date
S

Steve Stad

I would like to concatenate the text string..."Birthdays in " with the
expression =MonthName(Month(Now())). Can someone provide the correct
syntax.
 
I would like to concatenate the text string..."Birthdays in " with the
expression =MonthName(Month(Now())). Can someone provide the correct
syntax.
Click to expand...

="Birthdays in " & Format(Date(),"mmmm")
 
="Birthdays in " & MonthName(Month(Date()))
or
="Birthdays in " & Format(Date(),"mmmm")
 
Back
Top