Concatenate Expression with text string in Report?

[Steve Stad]

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

 

[fredg]

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

="Birthdays in " & Format(Date(),"mmmm")

 

[Duane Hookom]

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