Format String in Query

D

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?
 
F

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?
Click to expand...

MonthName([Myfield])
 
Top