Help: Sorting days of the week

  • Thread starter Thread starter ittutor
  • Start date Start date
I

ittutor

Is there a way of sorting the days of the week in their
normal order? If they were sorted alphanumerically they
would come up in the wrong order. Iwant them to start on
Monday or Sunday and then display in normal order.
Please reply to the address above.
 
Field is a text field with days of the week in as values.
When the whole table is sorted we want it to display in
normal weekday order starting Monday, Tuesday etc.
 
You should consider storing a value type that sorts properly such as 1, 2,
3,... You can sort an expression that uses your field:
DaySort: Instr("SuMoTuWeThFrSa",Left([StringDayField],2))
 
Back
Top