how to ORDER by more than 1 criteria

jaberwocky · #1 (**permalink**) 02-20-04, 17:25

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

gyuan · #2 (**permalink**) 02-20-04, 22:27

sql="SELECT * FROM AbsenceServicesQuery WHERE newDate BETWEEN #" & StartDate & "# AND #" & EndDate & "# ORDER BY newDate, dept ASC"

Internet Services

Web Development

Digital Marketing

Consumer Tech