Format String in Query

[David W]

Is there a way to format text in to a date?

I have a list of numbers in a field that ranges from 1-12 and I am wanting
to change them in a query to a month format to use in a combobox.

I tried in a Query
Expr1: Format([myfield],"mmmm")
with no prevail.

Any Ideals?

 

[fredg]

Is there a way to format text in to a date?

I have a list of numbers in a field that ranges from 1-12 and I am wanting
to change them in a query to a month format to use in a combobox.

I tried in a Query
Expr1: Format([myfield],"mmmm")
with no prevail.

Any Ideals?

MonthName([Myfield])