I have a table tblFlavor, which has the list of flavors in it. I use a combo box on a form to select the values from the list. I needed an option "Other" in the combo box so i set the rowsource property of the combo box to
SELECT flavor FROM tblflavor UNION Select "Other" From tblflavor ORDER BY flavor;
So the combo box now lists all the values from the tblFlavor table plus the "Other" which I added using the UNION query. Now I want the "Other" to be displayed at the end of the list rather than at the top of the list in the Combo Box.