Thread: Concatenate Expression with text string in Report?
View Single Post
  #3  
Old May 18th, 2010, 10:09 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
  
Posts: 7,177
Default Concatenate Expression with text string in Report?
="Birthdays in " & MonthName(Month(Date()))
or
="Birthdays in " & Format(Date(),"mmmm")

--
Duane Hookom
Microsoft Access MVP


"Steve Stad" wrote:

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