Re: Understanding How Access Sorts Records

your primary keyfield is likely causing the order of the records
to be displayed, by default, in some order OTHER than that
in which the records were entered. Best use a query to reorder
the records in the order that suits your needs.

Then, anytime you wish to refer to records in the table,
refer to them indirectly by use of the query used to order
them the way you like 'em.

Contrary to what beginners think, it is NOT important that
"records stay in the order in which they were added".
The fact that they STAY there is enough. I would com-
plain if they didn't stay there. Reordering them is painless
and instantaneous. You're not dealing with a shoebox
full of paper receipts here. It's a database. Sorting a shoe
box by hand is a job. Running a query to sort records
quickly is not.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


On Mon, 30 Jun 2008 07:56:53 -0700 (PDT), Takeadoe
<mtonkovich@xxxxxxx> wrote:

Greetings,

I'm hoping that someone can help me understand the method behind MS
Access' ordering of records within a table. It does not appear that
the records added last are always at the bottom when I open the
Table. It is important that the records stay in the order in which
they were added to the table. They clearly are not, but I can't seem
to figure out why the records are ending up in the order that they
are. Can anyone shed some light on this?

Thank you very much!

Mike

.

Relevant Pages

  • RE: Access 2007 - Overflow + error 2950 when running a macro
    ... Is the error a stack overflow or a numeric overflow? ... You usually have to look at the data that is causing trouble ... Through your tip I could restrict the query ...
    (microsoft.public.access.macros)
  • RE: Search facility query
    ... How does the code know which form to refer to if there is more than one? ... The two fields in "Query Entry" that contain the information are called ... Set rstClone = Me.RecordsetClone ... MsgBox "No Matching Customer Found" ...
    (microsoft.public.access.modulesdaovba)
  • Re: project track / log outstanding items list
    ... please refer to my last reply to Bob. ... replies to an original post, it is hard to query up / down the thread, ... please refer to my last reply to Bob on common ... Maybe I should use that design and give up the other option I was ...
    (comp.databases.ms-access)
  • Re: uer
    ... you can't refer to the ... >will have to put it in a standard module. ... been able to fiquire out how to do it from a query. ... >> I'm creating a query in design view. ...
    (microsoft.public.access.queries)
  • A2K Strange Characters in Distinct Query/Form Reference/combo box
    ... to unbound controls on the form. ... used because a SELECT query needs a table with records. ... Changed the query to refer to a table which I expect to have exactly one ... queries from Ken Snell: re Strange Characters. ...
    (microsoft.public.access.formscoding)