Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2002
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Listing Numbers (Access 2000)

    Hello:
    I can't think of the proper term right now, but what I want Access to do is order a list by a number field. My question is how to get Access to recognize that when I ask it to sort "A-Z" that the record "1108" should come after the record "301", not before.

    Thank you,
    Doug Lowry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Listing Numbers (Access 2000)

    Is the field you want to sort on defined as a number field? If so, 1108 should come after 301. However, if it is defined as a text field, sorting goes by "alphabet"; 1 comes before 3 so 1108 goes before 301. You can work around that by creating a query with an extra calculated column Val([NameOfField]), and use that for sorting.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing Numbers (Access 2000)

    Doug,

    If you are sorting on that field in your report and it is coming out in the order you mentioned then your field is Text and not Numeric. You would need to change the field to be numeric or enter all your text numbers with leading zeros. e.g. 0301
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

  4. #4
    Star Lounger
    Join Date
    Feb 2002
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listing Numbers (Access 2000)

    Thank you. You know I don't know what i was thinking, I should have checked this first.

Posting Permissions

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