Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2004
    Posts
    15

    Question Unanswered: Records mixed up ? :-S

    ok ive got a form which is a bit mixed up, the ID numbers are in order in the table from 11 - 36 but then in the form the exact same records are in the order of

    19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35 ,36,12,13,14,15,16,17,18,11

    anyone know why any help will be great thanks

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Specify the order:

    ....
    ORDER BY column
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    Open your form in design mode, open your properties box and in the 'OrderBy' property field, put the name of the field that contains your ID numbers.

    TD

  4. #4
    Join Date
    Jan 2004
    Posts
    15
    ok thanks for the quick response i will give it a go

  5. #5
    Join Date
    Jan 2004
    Posts
    15
    that worked great thanks very much

  6. #6
    Join Date
    Jan 2005
    Location
    Boucherville, Québec
    Posts
    4
    Quote Originally Posted by buckeye_td
    Open your form in design mode, open your properties box and in the 'OrderBy' property field, put the name of the field that contains your ID numbers.

    TD
    Hi,

    I have the same problem, I tried your solution, but it still does'nt work

    Any idea of what go wrong ?

    I'm on Access 97

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    are your fields containing numeric data actually numeric?
    if not, ie they are text or string then you need to reformat the data at data capture to insert additional spaces.
    You may be able to kludge it but converting the string to numeric for srting purposes. In either event if you are storing numbers as text then you data model is suspect. Even if there is a 'good' reason at the time the db was designed to store numbers as numeric, don't do it (unless of course you have to)

  8. #8
    Join Date
    Jan 2005
    Location
    Boucherville, Québec
    Posts
    4
    Quote Originally Posted by healdem
    are your fields containing numeric data actually numeric?
    if not, ie they are text or string then you need to reformat the data at data capture to insert additional spaces.
    It's an alphanumeric code (CM0001 to CM0160), and it's in a text field. But the db have no problem with that in the table (the sorting work).


    But, I tried to copy an other report, modify it, and the bug is gone ! Weird...

    Thanks for your help.

Posting Permissions

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