Hi all, old fashioned IT person, but not an access guru.

Require assistance in formating a date, ddmmyyyy to print on a report as
1st, 2nd 3rd, 4th, 13th, etc.

It's the day part I need to print the correct suffix.

The standard access format will print 1th, instead of 1st.

Any assistance will be appreciated.