Issues with sorting combo box on form

[RanaH]

Currently the combo box is displaying the data sorted by Category ID and I need it to sort by Category. Below is my Query...

Select Top 1 "(All)" as Category, 0 as CategoryID from tlkCategory
ORDER BY tlkCategory.Category

UNION ALL SELECT tlkCategory.Category, tlkCategory.CategoryID
FROM tlkCategory;

 

[Andrzejek]

What do you get when you do this:

[pre]
Select "(All)" as Category, 0 as CategoryID
from tlkCategory
UNION ALL
SELECT Category, CategoryID
FROM tlkCategory
ORDER BY 1
[/pre]


---- Andy

There is a great need for a sarcasm font.