Hide field in Union Query

[jsic1210]

Hello,

Is there a way to hide a field in a union query? I need to keep the field in the SQL statement because I need to order by it. The field is "Rank," but I don't want it showing up.

Thanks!
Jeff

 

[pbaldy]

I would simply hide it on the form/report using the union query, as I never let users directly into tables or queries anyway.

 

[jsic1210]

I don't allow users in the tables or queries either. The query is being exported to Excel.

 

[pbaldy]

I think you're stuck with exporting a query based on the union query then. As far as I know, the field(s) in the ORDER BY clause have to be in the first SELECT clause in a union query.