In Access, sort records by day name, Sunday, Monday, etc.

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

Guest

I need to sort records by Employee Name then Scheduled Days. Scheduled days
are in the table as text (Sunday, Monday). When I do a report, the days sort
out in alphabetical order. I've tried the Switch function to put them in
calendar order but it keeps telling me that I have an operand without an
operator.
 
You should really store the day values as 1-7 for more flexibility. However,
you can sort on the expression:

=Instr(Left([Schedule Day],2),"SuMoTuWeThFrSa")
 
Back
Top