[AccessD] MonthName Function Undefined - What's Missing?:

Ron Moore rmoore at comtechpst.com
Tue Aug 24 09:22:17 CDT 2004


Gary,

I don't know if it's 'standard', but I've always used 'Expression Name:
MonthName(Month([anydate]),True)' successfully in the past.  First time this
didn't work for me.

Ron

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Monday, August 23, 2004 12:42 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] MonthName Function Undefined - What's Missing?:


I do not recognise "MonthName" as a standard built in Access function. 
Perhaps its from some kind of add-in library you use?

I would normally obtain a month's name using the Format function with a 
"mmmm" parameter.

Gary Kjos
garykjos at hotmail.com





>From: "Ron Moore" <rmoore at comtechpst.com>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: [AccessD] MonthName Function Undefined - What's Missing?:
>Date: Mon, 23 Aug 2004 11:02:26 -0400
>
>To all,
>
>I installed an A2K app at a remote customer site and found that the 
>expression 'Time Period: MonthName([Period_Start_Date],True)' in one of 
>my queries raises the error 'Undefined Function MonthName in 
>Expression'.  I am told it was a full blown install of A2K, but 
>something appears to be missing.
>
>Any ideas?
>TIA, as always,
>Ron
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list