Results 1 to 6 of 6
  1. #1
    cover is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    3

    MS Access table question

    Hello, I have a table with 100,000 records in it and need to find away to read it from the bottom, or somehow flip it (ie sort) so I have the freshest entries first. There is no record ID or date on the entries to work on it from that perspective. So how do I 'up-end' the table to read most fresh records first?

    I'm trying to work with parcel number entries in ArcGIS and it reads the first parcel number it sees in the table. Given the most accurate data was written last, I need to flip this where I can 'sort A-Z' in a sense.



    TIA

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You would use a query to define a sort order but without anything to sort on I'm not sure you will get what you want.

  3. #3
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Given that you have no data field to indicate the order in which the records were written, you may be out of luck. If the parcel number values are reliably incremented numerically or alphabetically as they are created, you could sort in descending order on that field, since the "largest" value would be the latest one created.

    Access has no built-in record order, so there is no "first" or "last" record; it is up to the user to determine the order.

  4. #4
    cover is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    3
    Quote Originally Posted by RuralGuy View Post
    You would use a query to define a sort order but without anything to sort on I'm not sure you will get what you want.
    Kind of a tough one... I get this data from the county as-is and for lack of an entry date or record ID, hoped there may be a way to basically flip the table where in effect, I'd be reading the data from the bottom after flip and save.

  5. #5
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Is the data you get from the county assumed to be in the "correct" order, i.e. the most recent entry is the last one?
    and
    What format is the data in?

    If it is in a text file that you import, you might be able to add a field when you do the import that will allow you to retain the order.

  6. #6
    cover is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    3
    So far, I've exported the data from the access table to excel, added a column and numbered it numerically, then did a reverse sort to get the bottom of the table (newest entries) to top. Looks like something may work on that approach - will keep you posted.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-03-2014, 08:12 AM
  2. Replies: 2
    Last Post: 05-01-2014, 06:51 PM
  3. Replies: 25
    Last Post: 04-03-2014, 02:04 PM
  4. Question about Times in Access Table
    By Littlma in forum Access
    Replies: 1
    Last Post: 08-02-2011, 07:00 AM
  5. Access Table - Relationship Question
    By vixtran in forum Database Design
    Replies: 5
    Last Post: 06-12-2009, 10:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums