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

Thanks Gustav! I was beating my head against the wall.

Since it seems there was a lapse in mail yesterday, I tried some string
manipulation and nested IIFs, but it got ugly quick.  So I just created a
static table (1-12 with month names) and used the Month function and linked
to the lookup table.  Probably not the best solution, but time was of the
essence.

Thanks Again,
Ron

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, August 23, 2004 11:33 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MonthName Function Undefined - What's Missing?:


Hi Ron

This is an old bug that may not have been solved yet:

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;225956

/gustav


> 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