data 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. 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
 
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 ...
 
Back
Top