Function myOrdinal (D as Integer) as String Dim Suffix as String Select Case D Case 1, 21, 31: Suffix = "st" Case 2, 22: Suffix = "nd" Case 3, 23: Suffix = "rd" Case Else: Suffix = "th" End Select myOrdinal = D & Suffix End Function
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 27.