Sorting by month field

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?
 
R

RonaldoOneNil

Answered in your other post, but you should not use field names Month Day
Year as these are reserved access date functions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top