Extracting * Sorting DAY of Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am using Access 2000 and have set up a field named "Birth Date" which is
in the format of mm/dd/yyyy. I need to SORT all of the data records into the
"DD" sequence for use in the REPORT that I am trying to do.

Can anyone suggest how best to proceed please?
 
If this is a date field, set the sorting expression to:
=Format(DatePart("d", [Birth Date]), "00")
 
Back
Top