Concatenate Expression with text string in Report?

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

="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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
expression to concatenate text strings omitting empty records?	=?Utf-8?B?ZGJuRGF2aWQ=?=	Microsoft Access Getting Started	6	28th Mar 2006 10:42 PM
how do I write an expression to concatenate text	=?Utf-8?B?aGFpbHM=?=	Microsoft Access Form Coding	3	19th Nov 2005 12:17 AM
concatenate a text string if two different cells contain the sam.	=?Utf-8?B?TGluZGEgRw==?=	Microsoft Excel Worksheet Functions	5	17th Jan 2005 07:53 PM
Concatenate: Text String and SUM Results	CEJ	Microsoft Excel Worksheet Functions	1	25th Oct 2004 03:52 PM
Re: Concatenate: Text String and SUM Results	Aladin Akyurek	Microsoft Excel Worksheet Functions	0	25th Oct 2004 03:46 PM