Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005

    Unanswered: Records won't show in numerical order

    I recently upgraded from access97 to access 2003. The process has fortunately been unenventful, but I've noticed one problematic change (anomaly) that I don't understand.

    I routinely run a make-table query, to compile data and build a products file for an online store.
    Before the upgrade, when I ran this query, any new records in the related tables would show up in the "made-table" located according to numerical order.

    Now when I run the query, the newest records are all at the top of the table. I can't figure out why this might be happening and I can't figure out how to make them show up in numerical order again.

    This is problematic, because with the items out of order in the products file, they're displaying in the wrong order on the web in the online store.

    Anyone know what might be happening here?
    Thanks in advance.
    Who imported me here?

  2. #2
    Join Date
    Jan 2005
    doh. I'd forgotten about the sort option in query design.
    Simply choosing "sort ascending" for the skuid field solved the problem.
    Thanks for being here.
    Who imported me here?

  3. #3
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    "Physical order of record in a table have no meaning."

    I think I have a stone with that written in it running around somewhere...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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