
May 27th, 2015, 10:50 AM
|
Contributing User
|
|
Join Date: Feb 2011
Posts: 39
Time spent in forums: 6 h 35 m 3 sec
Reputation Power: 8
|
|
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 10:53 AM.
Reason: Adding code
|