+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Sorting in MS Access in Technical; I have an Access database which we use for recording our hardware. We label computers with the room number followed ...
  1. #1

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22

    Sorting in MS Access

    I have an Access database which we use for recording our hardware. We label computers with the room number followed by a dash then the computer number i.e. Room1-01 etc. When I try to list them in order I get Room10-09, Room1-01, Room10-10; similarly Room1-10, Room11-01. Obviously Access is ignoring the dashes. Does anyone know of a way round this without rejigging our whole naming convention.

  2. #2
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25
    The obvious thing to do is add a 0 before the room - so room1-10 would become room01-10.

    But this might be what you meant by not changing the entire convention.

    So your other option is to add a couple of fields to the table, one for room and one for computer number and then an action query that will strip out the room number and computer number to drop them into those fields.

    Then you could sort by those columns instead of the single column.

  3. Thanks to limbo from:

    Hecate (27th April 2010)

SHARE:
+ Post New Thread

Similar Threads

  1. Flash - sorting out a mess....
    By kennysarmy in forum Windows
    Replies: 10
    Last Post: 12th March 2010, 01:29 PM
  2. Sorting levels in Excel - eg 2a 2b 2c
    By rocknrollstar in forum Office Software
    Replies: 4
    Last Post: 15th September 2008, 07:21 PM
  3. Sorting Music
    By OutLawTorn in forum How do you do....it?
    Replies: 10
    Last Post: 23rd November 2007, 11:10 AM
  4. Sorting Programs List by Name
    By Midget in forum Windows
    Replies: 17
    Last Post: 24th January 2007, 11:04 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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