Problem:Records are getting automatically sorted.

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

What you have is a series of records containing text. Access doesn't know
what you want to do with it. You could create another field called
SortOrder and number the days accordingly, then sort the records in a query.

Keith.
www.keithwilby.com

 

[FredFred]

1. Get rid of any unwanted sorting. This includes any obvious query grid
and design sorts, plus hidden ones by: records -> remove filter sort

2. Enter the date instead of the day of week. Create a calculated field
=weekday([yourdatefield]) in a query (or whatever you're viewing it in) and
sort by that.

A lower tech method would be to enter a code for the day of week (Sunday =
1, Monday = 2" etc.) instead of the day of week.

Whenever yo want to see the word of the day of the week, just create a
little table that gives that conversion (date code and day of week) and
link to it.

 

[John W. Vinson]

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.

A Table

* H A S N O O R D E R *.

A table is an unordered "heap" of data. It's also not designed or intended for
interacting with or editing the data - it's designed for storing the data!

If you want to see records in a particular order, you must - no option! - use
a Query sorting the records; or a Form with an sort order specified in its
Order By property.

John W. Vinson [MVP]