Ron Moore
rmoore at comtechpst.com
Tue Aug 24 09:25:38 CDT 2004
Max, not the wrong end of the stick at all. I had simply always done it the other way (the function name was self explanatory) but will be changing to your approach for future work. Ron -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MG Sent: Tuesday, August 24, 2004 9:53 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] MonthName Function Undefined - What's Missing?: Ron, I may have the wrong end of the stick here, but if you want month names then just use the format function, viz. ? format(date,"mmmm") gives August ? format(date,"mmm") gives Aug Max Sherman -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ron Moore Sent: 24 August 2004 14:38 To: 'Access Developers discussion and problem solving' Subject: RE: [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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com