union query sort

[Souris]

I have an union query to create a report.

The union query sort by alphabetical.
For some reason, I need the order base on user entered.

Are there any way to set the result not sort in union query?


Your help is great appreciated,

 

[John Spencer]

No, you have to include a field (or fields) that can sort the records in the
order you require.


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Jerry Whittle]

Don't sort in the query. Rather use the Report's sorting and grouping options.

 

[Souris]

Thanks millions,

No, you have to include a field (or fields) that can sort the records in the
order you require.


--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..