Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    1

    Unanswered: Records Sort using WBS numbering

    There may be a simple solution to this one, but I sure haven't been able to find it!
    I'm using a form to capture comments on a document and am referencing the paragraph number which is in the Work Breakdown Structure numbering system. I need to be able to sort the records (using a query) by the WBS sequence. Problem is, Access sorts like so:
    1.2.3.1
    1.2.3.11
    1.2.3.2
    1.2.3.3
    1.2.3.4

    But I need the sort to follow the WBS system and come out like so:
    1.2.3.1
    1.2.3.2
    1.2.3.3
    1.2.3.4
    1.2.3.11

    Can anyone help or direct me to a resource or tip or something to get this fixed?

    Thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ...consider creating a hidden (is used only wihtin the db) field, which can be used for sorting. redefine the WBS in that field to be a fixed format string, so instead of 1.2.3.11, store it as 01.02.03.11, or even 001.002.003.011... that is if you think you will need upto 100 sub sections. if its only the last group then you could probably get away with 1.2.3.01.

    you could store the data in the wbs column including leading zeros, and then strip these out using a function (say that repalces '.0' with '.')
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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