May 27th, 2015, 11:50 AM
|
|
Contributing User
|
|
Join Date: Feb 2011
Posts: 39
Time spent in forums: 6 h 35 m 3 sec
Reputation Power: 9
|
|
|
Sorting a list box with selected items first
I have a list box that allows multiple items to be selected. On a form, I would like to sort the list with the checked items first and the remaining items in Alphabetical order.
I attempted to edit the query which controls the list box but haven't found a way to sort by the selected items.
Code:
SELECT tblSideItems.ID, tblSideItems.SideItem
FROM tblSideItems
ORDER BY tblSideItems.[SideItem];
Last edited by runner1050 : May 27th, 2015 at 11:53 AM.
Reason: Adding code
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
