Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Ephrata, Washington, USA
    Thanked 0 Times in 0 Posts

    Table Comparison messes up order (97 sr2)

    A friend sent me this email: I created a table without a primary key. (I can't have a primary key because there are two fields with the same name.) I'm doing a comparison between two tables, but after doing the comparison, the first table is all out of order. Any idea why?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: Table Comparison messes up order (97 sr2)

    Tables are not "in order" or "out of order". They are just lists of data. To view them in order, you can sort them or assign a primary key (which is used to sort the data for display, if no other sort order is specified). Without a primary key or a specified sort sequence, there is no way to predict the order in which Access will present the data.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts