Re: Removing sort from index

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ronnie (Ronnie_at_discussions.microsoft.com)
Date: 11/17/04 

Date: Tue, 16 Nov 2004 16:44:10 -0800

Thanks Marshall

The data which is displayed on the forms from the status table, are from a
query called appointmentstatus. There is no sort order in this query so the
sort is not from this query. This has led me to the conclusion that it is
the index which is causing the problem.

"Marshall Barton" wrote:

> Ronnie wrote:
>
> >I have a table called status in my database. I have two primary fields in
> >this table called the following
> >
> >Appointmentid Number
> >Status Text
> >
> >This index stops duplication of records when Appointmentid and status are in
> >combination. This works fine. The problem I have is that the records when
> >entered on a form always go into alphabetical order. So if I choose
> >
> >Appoinmentid as 6 status = new
> >Appoinmentid as 6 status = completed
> >
> >when the record is saved and displayed as
> >
> >Appoinmentid as 6 status = completed
> >Appoinmentid as 6 status = new
> >
> >This is frustrating as it is not displaying records in the order they are
> >entered. I have tracked this down to the index fields sorting the records as
> >ascending in table design view, but there is no way in table design to remove
> >the sort.
>
>
> The order you're seeing is just Access (not the table)
> providing a guess as to how it thinks you might want the
> data sorted for table *** view. Since tables in a
> relational database are by definition unsorted, you must use
> a query to specify how you want the data displayed.
>
> --
> Marsh
> MVP [MS Access]
>

Quantcast