Thread: Concatenate Expression with text string in Report?
View Single Post
  #2  
Old May 18th, 2010, 09:43 PM posted to microsoft.public.access.reports
fredg
external usenet poster
  
Posts: 4,386
Default Concatenate Expression with text string in Report?
On Tue, 18 May 2010 13:04:01 -0700, 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.

="Birthdays in " & Format(Date(),"mmmm")
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail