Order in a Union Query

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

I would have assumed if you left out the "order by" in a union query it
would combine the queries in the order entered. Nope. It still sorts all the
results starting from the left most field 1st. I don't want that. The order
I enter them is the order I want. Is there anyway to work with that? To
hardwire the order I want?
I'm a meteorologist. I'm using the results of up to 8 different single line
crosstab queries into one. I want them in the order listed but access isn't
cooperating. It should be in this order.
Parameter Jan Feb............................Dec Annual (field
labels)
Extreme Max Temp
Mean Max Temp
Mean Temp
Mean Min Temp
Extreme Min Temp
# Days GE 90
# Days LE 32
# Days LE 0

Access wants to sort these so the ones starting with #, Extreme, etc are
output 1st. That's not the order I put them in the union query.
 
Add another column to your query indicating the order in which you want them
sorted.
 
Back
Top