Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Order Of Query Results not working (Access 2003)

    I have a query which shows product info and stuff. The user can specify what they want to search by, and select how they can order it

    In my query, i am reading the values from the form and the order is displayed properly (EG, Name ASC)

    But when I have a listbox that shows the results from the query, the results are displayed in RANDOM order, not the order selected by the user. Therefore, the query is build properly (as it displays the results how I want, but when a listbox uses that query, the order is random

    Ideas?

    Thanks

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Order Of Query Results not working (Access 2003)

    Can you show us the code you use to translate the user's selections in modifications of the query.
    Regards
    John



Posting Permissions

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