title: How to repair "order by" after union of 2 selects from 1 tables
body: <p>I have a dropDownList on my form, where i need to have union of values from 2 colums of table [ost].</p>
  
  <p>Type of this columns is currency.
  I have russian version of access, default value of curency in "rur" and i need "uah".
  I need to change format and save "order by".</p>
  
  <p>I use this query:</p>
  
  <pre><code>(SELECT distinct FORMAT([Sum1] ,'# ##0.00" uah.";-# ##0.00" uah."') FROM ost) 
  Union 
  (SELECT distinct FORMAT([Sum2],'# ##0.00" uah.";-# ##0.00" uah."') FROM ost)
  ORDER BY 1
  </code></pre>