Hello,

Perhaps you can look into the "Switch" function.

Example:

Switch([MonthName]="January",1,[MonthName]="February",2,[MonthName]="March",3,[MonthName]="April",4)

Happy hunting.
Regards

jerry.ranch@pioneer.com wrote:
> I see that DateSerial can be used to "concatenate", in a way, three
> fields DateSerial(year, month day) into a date field (if year , month
> and date are numeric values). Unfortunately, my Month field is Text
> (January, February etc).
> What function is used to convert text month to numerical 1-12?
> Thanks
> Jerry