Help: Sorting days of the week

[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.

 

[Duane Hookom]

What type of field do you have and what are some sample values?

 

[ittutor]

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.

 

[Duane Hookom]

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))