data auto sorting problem

[Dips]

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.

 

[Keith Wilby]

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.

Please don't mult-post. Answered in tablesdbdesign.

 

[Lance]

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

 

[Larry Daugherty]

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