Re: Removing sort from index

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 sheet 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]
>

Relevant Pages

  • Re: strange query sort behaviour
    ... We are using a printing / merge program that attaches directly to the access ... I need to 'sort' this probelm somehow... ... Now that you understand the situation, create a query that ... Displaying a table in sheet view is just asking Access to ...
    (microsoft.public.access.queries)
  • Re: Sorting by Month problems with Combobox
    ... apart to use them in a query, or report? ... >>I can get it to sort by month number, displaying the ... >>in text in a QUERY. ... >Report's Sorting and Grouping section sort by the month ...
    (microsoft.public.access.queries)
  • Re: Sorting by Month problems with Combobox
    ... >In the query for the report include the sort column. ... >> I can get it to sort by month number, displaying the ... >> report based on the query, it lists the months in ...
    (microsoft.public.access.queries)
  • Display all fields that are yes in a table in one box
    ... Im trying to create a report & query that displays a list of fields that ... are checked yes in a table,Rather than displaying All the fields and ... sort of... ...
    (microsoft.public.access.gettingstarted)
  • Re: Make Table Query - Sorting Errors
    ... Dim OutputTable As DAO.Recordset ... The query to concatenate the CAMPNO values will need to be LOOKING at the ... If you post the query you are using to do this, I beleive we can get it to ... Is there a command that I can use in the module code to first sort the ...
    (microsoft.public.access.queries)