sorting days of the week

  • Thread starter Thread starter Looker
  • Start date Start date
L

Looker

Guest
can anyone tell me how to sort days of the week into this format I.E. Mon, Tue, Wed, Thur as apposed to alphabeticaly the way access defaults to.

Regards and thanks
 
You need to use a conversion function and sort on the output of that function. Check out weekday()
 

Users who are viewing this thread

Back
Top Bottom