Prev: Report Formatting
Next: Report not executing code
From: Steve Stad on 18 May 2010 16:04
I would like to concatenate the text string..."Birthdays in " with the
expression =MonthName(Month(Now())). Can someone provide the correct
syntax.
From: fredg on 18 May 2010 16:43
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
From: Duane Hookom on 18 May 2010 17:09
="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.
 | 
Pages: 1
Prev: Report Formatting
Next: Report not executing code