'Alias' and 'Order By' Troubles with Union Query?

[crazy_loud]

Hello all,

Does anyone know (and would be willing to share) how one can order the results of a Union query in Access by something other than the returned values?

I have a simple Union query that would work perfectly - if I could get the thing to order the results in a particular order everytime. The query returns counts (all from one table) of separate select statements that each meet certain conditions (e.g. having state=Nevada, having state=California, etc.) as records - but since Union queries in Access order results in ascending or descending order by returned value, it puts my records in a different order every time the record values change. I need to have them ordered the same way (in the same order as they appear in the Union query, if possible) everytime so that I can return those values to specific cells in MS Excel. Any suggestions would be much appreciated!

 

[crazy_loud]

Sidenote...

Ignore 'Alias' in the title - I started a new thread instead and forgot to delete that

 

[WayneRyan]

Crazy,

The Union query has no means to perform a sort.

Have another query use the Union query as its input. The second query
can do the appropriate sorting for you.

Wayne

 

[crazy_loud]

Thanks Wayne!