How can I convert the numerical representation of a
month/date to it's english equivilent?

Thanks!

Hello James,

Use the function MonthName. I have copied and pasted the Help entry for you:

MonthName Function

Description:
Returns a string indicating the specified month.

Syntax:
MonthName(month[, abbreviate])

The MonthName function syntax has these parts:
PartDescription
monthRequired. The numeric designation of the month. For example, January is
1, February is 2, and so on.
abbreviateOptional. Boolean value that indicates if the month name is to be
abbreviated. If omitted, the default is False, which means that the month
name is not abbreviated.

Cheers,

Jerome

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.417 / Virus Database: 233 - Release Date: 08-11-02

try to use:
format(#11/1/1#,"mmmm")

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com

And generalizing this idea, if you have the month number in, say,
[MonthNo], you could use the following expression:

    Format(DateSerial(1, [MonthNo], 1), "mmmm")

If you have a complete date, you can use just

    Format([DateField], "mmmm")

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)