Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Table Property

    Access 97; I have a table: field1 is long integer (but not autonumber), field2 is integer, field3 is text. I want the table sorted on the text field, without having to sort it each time I open it. I have set the table property to Order by: field3. I have put field3 in quotes, in brackets and naked. Access ignores field3 and sorts on field2.

    Can you tell me why?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Property

    Have you indexed the Field "Field3" ?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Table Property

    No. Should I? And if I should, why don't the Access instructions say so?

    -- If I index, yes, it does sort on that field. And I don't need the OrderBy property. Now I'm confused. Should the OrderBy property work as I used it? It seems as though there are two ways that should work, but one of them does not.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Table Property

    I have never figured out what OrderBy is supposed to do on a table. Forget about it and use the indexes, which will work consistently. An OrderBy property on a table doesn't make sense anyhow.
    Charlotte

Posting Permissions

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