S sherwin Jul 15, 2009 #1 ni'd like to covert the day like 1 to first, 2 to second, and so on, how do i do that? any code?
D Douglas J. Steele Jul 15, 2009 #2 You'll need a VBA function to do it for you. http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web" may give you an idea.
You'll need a VBA function to do it for you. http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web" may give you an idea.
J John W. Vinson Jul 15, 2009 #3 ni'd like to covert the day like 1 to first, 2 to second, and so on, how do i do that? any code? Click to expand... In addition to the suggestion of VBA code, you could just create a little 31 row table with values 1 First 2 Second 3 Third .... 31 Thirty-first Use this table in your report with no join line, just use a criterion on the number field of =Day([datefield]) or else use =DLookUp("DayName", "ThisLittleTable", "DayNumber = " & Day([datefield])) in an expression.
ni'd like to covert the day like 1 to first, 2 to second, and so on, how do i do that? any code? Click to expand... In addition to the suggestion of VBA code, you could just create a little 31 row table with values 1 First 2 Second 3 Third .... 31 Thirty-first Use this table in your report with no join line, just use a criterion on the number field of =Day([datefield]) or else use =DLookUp("DayName", "ThisLittleTable", "DayNumber = " & Day([datefield])) in an expression.
