data auto sorting problem

D

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

Keith Wilby

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

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

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
 
Top