Sorting Form by Date (mm-dd format) - Ascending Order?

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

Guest

I have a field called "follow up date" that I use and enter the date I want
to follow up on with my potential customers. I use the following format
mm-dd, such as:

6-06
8-12
Etc.

I have it sorting in ascending order. However, it is treating 10, 11, 12
months as being before 6, 8, etc. because of that 1.

Any help on the code so it will sort it correctly?

Thanks
Curtis Stevens
 
It looks to me that your Field is a Text Field, not a date Field and if it
is a Text Field, "1" will come before "6".
 
Sorry, had a dull moment there! I thought of this as I posted it... Been
working too much I guess. I will just change it to a date format for the
field and will work out just fine....

Thanks
Curtis
 
Another option is to handle thin in the query! Add another column, one
that's not returned (don't check the checkbox) and put the date formatted in
that field which will achieve the seqired sequence. Sequence the recordset
on that column.
 
Back
Top