Union Query fields

[Xarkath]

Hello,



When buiding a Select statment in a Union Query is it possible to reference the column numbers instead of the column headers. If so, what would be the correct syntax? I tried to Google this but I could not find anything on it.

Thanks

[June7]

Never heard of this and I doubt can do this in query. AFAIK, index referencing is VBA. As evidenced by the fact queries will not recognize combo or list box column index.

[orange]

I don't think that is possible. The closest I recall is in Order By which works in Access.

example

SELECT last_name, department_id, salary 
   FROM employees 
   ORDER BY 2 ASC, 3 DESC, 1;