data auto sorting problem

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

Guest

Dear all,
i have access version 2002 (10.2616.2625). I have created a table having
sunday, monday, tuesday etc. But, Ms-access is automatically sorting the
field and taking Friday first. But, i want sunday first.

Plz help.
 
Dips said:
Dear all,
i have access version 2002 (10.2616.2625). I have created a table having
sunday, monday, tuesday etc. But, Ms-access is automatically sorting the
field and taking Friday first. But, i want sunday first.

Plz help.
Click to expand...

Please don't mult-post. Answered in tablesdbdesign.
 
"friday" & "sunday" are strings, they'll be sorted alphabetically, and F is
before S.

If you want to sort in day of week order, you’ll need to either replace the
text in your table with a number, or write a function which converts the text
to a number.
 
Look in Help for Date and Time functions. You can find how to get the
numeric day of the week and use that value for your sort. Typically
you'd create a new field in your query like DayOfWeek:
=format([MyDateField], "w") and Sort Ascending.

HTH
 
Back
Top