How sort by year-month order on a form?

  • Thread starter Thread starter John Matteson
  • Start date Start date
J

John Matteson

I have a form based on a table with a field "placeDate"
of type= date/time. I set the orderby to this control
and it sorts by month-day-year order. This is nice for
comparing mothly totals from year to year, but I want the
orders all in order where orders for Nov 2002 are
followed by Dec 2002.
I tried setting the orderby to "[Year([placeDate])],
[Month([placeDate])], [Day([PlaceDate])] but it still
sorts the same way.
If I do a query on the table and set it to sart on the
placedate field, it sorts it in the correct order.
I'm setting the OnSortBy field to true in the table open,
and I can sort on other fields but not date in the
correct order.
?????????????????????
 
Base the form on the query that sorts the way you want it, rather than
basing it on the table.
 
Back
Top