Sorting a date field in a query 1

[misha8765]

Thank you in advance for your help.

I have a date field 99/99/00

When I sort ascending in a query, it sorts the year first.

I want it to sort by month then day. Any idea?

Thank you

 

[Golom]

Is the data type of the field a datetime field?

If it is then the order you are seeing is the order that you get when you sort by the whole field.

Try something like

Order By Month(DateField), Day(DateField)

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[misha8765]

Thank you,

Where exactly would I put this code. The format is datetime

 

[Golom]

Switch to SQL view in your query and paste it in as the "ORDER BY" clause. Be sure to change the field name to the correct one for your query.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]