Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Vancouver
    Posts
    17

    Unanswered: how to ORDER by more than 1 criteria

    Can someone tell me how i would use the ORDER BY code to show data in a table using more than one criteria ie:
    Code:
    sql="SELECT * FROM AbsenceServicesQuery WHERE newDate BETWEEN #" & StartDate & "# AND #" & EndDate & "# ORDER BY ""newDate"", ""dept"" ASC "
    right now i am ordering my results by 'newDate', but i also want to have it ordered secondarily by 'dept'. I tried the above, but it doesnt work
    thanks
    still in the baby steps of coding

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    sql="SELECT * FROM AbsenceServicesQuery WHERE newDate BETWEEN #" & StartDate & "# AND #" & EndDate & "# ORDER BY newDate, dept ASC"

Posting Permissions

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