If formula with more than one condition

[carolineJ]

I have a field called month in a table with values from 1-12. In my query I want a calculated field that shows the name of the month instead of number, i.e if field month is 5 then the calculated field is "May". I think I can do it for two months (if month = 1 then "January" or else "February&quot but how can I have more than one condition so that I can continue with the rest of the months?

 

[Maquis]

Use a format statement to show the months instead.
Format([yourdatefield],"mmmm&quot Maq B-)
<insert witty signature here>

 

[tlbroadbent]

You can use the Choose function in a query. Choose selects the entry in the list based on the number in the Choice criteria which is the 1st parameter.

Choose([Month], &quot;January&quot;, &quot;February&quot;, &quot;March&quot;, ..., &quot;December&quot
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.