data formating

[jlnewbie]

I want to format date as follows
"15th day of March, 2004"
or "3rd day of March, 2004"
but I don't see that format as one of my formating options in access or am I missing something. Is there a function out there that will do this?
Thanks in advance



JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[BNPMike]

They dropped that in Access 1725.

 

[jlnewbie]

thanks bmpmike but I found out how to format it anyway. It does'nt give me the rd or th after day but it works



JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service