USMarine430
New member
- Local time
- Today, 10:52
- Joined
- Feb 2, 2012
- Messages
- 6
I have a text box which feeds of of the control source labeled as "month" - this column has nothing but the numbers 1-12 in it. And so appears in the text box is this number.
The report prompts the query which has the string:
Like IIf(IsNull([forms]![frmrepotsform]![cbomonth]),"*",([forms]![frmrepotsform]![cbomonth])) - singling out the month for the report asked - which is the month (number) that appears.
The title sums it up - I am wondering if there exists the means to convert the numbers 1-12 (not belonging to a series of other numbers or anything else that would represent a date) to word value of a month. I know that "mmmm" is representative of converting something to the month name - but how would you use the expression builder to convert a single set of numbers to a month name?
Semper Fi-
Dave
The report prompts the query which has the string:
Like IIf(IsNull([forms]![frmrepotsform]![cbomonth]),"*",([forms]![frmrepotsform]![cbomonth])) - singling out the month for the report asked - which is the month (number) that appears.
The title sums it up - I am wondering if there exists the means to convert the numbers 1-12 (not belonging to a series of other numbers or anything else that would represent a date) to word value of a month. I know that "mmmm" is representative of converting something to the month name - but how would you use the expression builder to convert a single set of numbers to a month name?
Semper Fi-
Dave