Perhaps you can look into the "Switch" function.
> 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?