convert number to word

[ariel81]

i have a field inside a table. the data in the field is in number, how can i convert the number to word inside a report?

e.g:

1 (data inside a table field) convert to "Jan" upon display in a (report textbox)
: :
: :
12 (data inside a table field) convert to "Dec" upon display in a (report textbox)

 

[namliam]

How about you make it a date field and put the format of "MMM" on to it, this would display what you are looking for...

 

[ariel81]

the month field of the table was initally in number format.
if i change it to date/time format then the month number data will go haywire...

wonder if there's anyway to convert the number to word in report design

 

[KeithG]

Use the MonthName function.

 

[ariel81]

ok thanks, at the report textbox control source i set to "=MonthName([tblFltMonth])" , it works...

 

[namliam]

MonthName function.

Is there such a function??? Geez, you learn something everyday...