Sorting by month field

  • Thread starter Thread starter NEHicks
  • Start date Start date
N

NEHicks

I have a very simple query with the following fields:
Org Unit Last Name First Name Month Day Year

All fields are text fields, except for Day Year - they are number fields

When I query by year, I want to sort the months in chronological order, not
alphabetical.

How do I do this?
 
Answered in your other post, but you should not use field names Month Day
Year as these are reserved access date functions.
 
Back
Top