Sorting problem

[Guest]

Hi and thanks for the help. I am using Access 2003. I have a simple table
with 15 fields. One of the fields contains the date data type. In the data
view of the table I have selected the date field and clicked the Z to A
button to do a descending sort. The sort holds until I exit the database and
return. Upon returning my sort is lost. I have the database set to compact
and repair each time it closes.

Should the sort hold ? Any thoughts as to what is going on. THANKS. Sheri
: )

 

[Allen Browne]

The sort in the table is not reliable.

Instead, create a query using this table, and specify the sorting you want
under the date field. Save the query. Use it instead of the table. The
sorting will be reliable.

 

[Joseph Meehan]

Hi and thanks for the help. I am using Access 2003. I have a simple
table with 15 fields. One of the fields contains the date data type.
In the data view of the table I have selected the date field and
clicked the Z to A button to do a descending sort. The sort holds
until I exit the database and return. Upon returning my sort is lost.
I have the database set to compact and repair each time it closes.

Should the sort hold ? Any thoughts as to what is going on. THANKS.
Sheri

Tables don't have sorts. The data in a table does not exist in any
specific order. If you want data to appear in a specific or consistent
order, you need to define that order and may need to add a filed to maintain
the order. In any case the table, which is designed to hold data and field
descriptions, not view and edit, will not show consistent order, you need to
use queries, forms and reports for that.

 

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

Create a query and maybe a form/report based on that query.
It's good to create index if you want your sort to run faster.

Vlado