L Looker Guest Jan 17, 2002 #1 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
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
M MrTibbs Registered User. Local time Today, 03:12 Joined Oct 10, 2001 Messages 101 Jan 18, 2002 #2 You need to use a conversion function and sort on the output of that function. Check out weekday()