Results 1 to 2 of 2
  1. #1
    raceware is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2010

    Unhappy Displaying Records & Sorting Help

    I am a complete novice to Access used an old dos program for years so bare with me. I have converted my old dos files to Access & I can't figure out how to have the records displayed in a "Sorted " fashion. We kept our records using what we call a Shop Order so for example 10-1000 for internal use which would breakdown the 10 being the year 2010 & the 1000 would be the first record for that year and we use the 10 prefix throughout the year only change the last 4 digits each time a new job is entered. What my dilemma is our oldest is lets say 91-1051 to present 10-1071 how can I get them to sort & display each time the Database is opened to be sorted & displayed in progression from 91-????, 92-???? & so on all the way to present 10-????. Any Hints?

  2. #2
    michaeljohnh is offline More Human than Human
    Windows XP Access 2007
    Join Date
    Aug 2010
    Sorting by itself is a snap. A query can do this for you because there is a built in field call Sort which allows you to sort by ascending or descending order. Its the making of 90, 91, 92 etc come before 08,09,10 a little trickier.

    A couple solutions would be to add a field to the table to hold the first two digits of the year. You would run an append query that populates the field with either a 19 or a 20 and then sort by that field.

    Another possibility would be to create a concatonated field that prefixes 19 or 20 to the ticket number then sorts it that way.

    If you like either of these ideas I can provide more detail.
    Last edited by michaeljohnh; 09-29-2010 at 06:37 AM. Reason: editted for clarity

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

Similar Threads

  1. Sorting records
    By Samu77 in forum Access
    Replies: 1
    Last Post: 09-13-2010, 10:40 PM
  2. Sorting Records
    By sfoot0309 in forum Reports
    Replies: 1
    Last Post: 02-05-2010, 05:50 PM
  3. Sorting records
    By BravoEcho in forum Queries
    Replies: 0
    Last Post: 06-23-2009, 04:49 AM
  4. Best way of displaying and printing records?
    By Orabidoo in forum Access
    Replies: 1
    Last Post: 05-11-2009, 10:05 AM
  5. Displaying records from a form
    By ceb39 in forum Access
    Replies: 5
    Last Post: 04-03-2009, 12:36 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 - Senior Forums