data sorting problem

[Dips]

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

Plz help.

Thank you.
Anz

 

[Allen Browne]

By default, Access sorts a table by the primary key.

If you want it sorted differently, add another field to decide the sort
order, e.g.:
DayID DayName
==== =======
1 Sunday
2 Monday
3 ...

 

[Dips]

Thanks a lot.