simple syntax ?

[markjkubicki]

I have a query [qryFixtureType_sort normal] which includes 2 expressions that the query is sorted on (exp1, exp2); and the query results in a correctly sorted datasheet;
I am using that query as the datasource for a listbox.

the field that I want to display in the listbox is the unfortunately named (I inherited it, and it seems to be used EVERYWHERE -UGH!): "Type"


when I enter the source as below, the full recordset is included, and it is sorted correctly
[qryFixtureType_sort normal.Type]

when I include a union, as either of the below - which is ultimately what I want, the full recordset is included, but it is not sorted




SELECT [qryFixtureType_sort normal.Type] FROM [qryFixtureType_sort normal] UNION Select "< ALL >" FROM [qryFixtureType_sort normal];

SELECT [qryFixtureType_sort normal.Type] FROM [qryFixtureType_sort normal] ORDER by exp1, exp2 UNION Select "< ALL >" FROM [qryFixtureType_sort normal];


any thoughts would be greatly appreciated in advance
Mark

[rpeare]

Build your union query first. Base the listbox on a query of the union query ordering it to sort the way you want it. That's probably the easiest way

[pbaldy]

The only place you can have an ORDER BY clause is in the last SELECT statement, though it would need to use field names from the first. More accurately, that's the only place it will work.