date format

[sherwin]

ni'd like to covert the day like 1 to first, 2 to second, and so on, how do i
do that? any code?

 

[Douglas J. Steele]

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.

 

[John W. Vinson]

ni'd like to covert the day like 1 to first, 2 to second, and so on, how do i
do that? any code?

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.