Concatenate Expression with text string in Report?

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.
 
F

fredg

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")
 
D

Duane Hookom

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