Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Unanswered: Sort Data in a list box

    I need to sort data that is in a list box. I have sorted the information in the query but it doesn't change the order in the list box. What is the SQL statement to order them in A-Z. The current SQL is

    SELECT [Report Name].ReportName
    FROM [Report Name];


    What else do I need to do to order by Report Name?

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Your answer is in your question

    ORDER BY REPORTNAME
    Inspiration Through Fermentation

  3. #3
    Join Date
    May 2005
    Posts
    1,191
    Quote Originally Posted by dendalee
    I need to sort data that is in a list box. I have sorted the information in the query but it doesn't change the order in the list box.
    How have you already tried sorting?
    Quote Originally Posted by dendalee
    What is the SQL statement to order them in A-Z. The current SQL is

    SELECT [Report Name].ReportName
    FROM [Report Name];

    What else do I need to do to order by Report Name?
    Have you tried the ORDER BY clause at the end?
    Me.Geek = True

  4. #4
    Join Date
    Dec 2003
    Posts
    138
    Gee I feel stupid, thanks for waking me up!

Posting Permissions

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