union query sort

  • Thread starter Thread starter Souris
  • Start date Start date
S

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,
 
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
..
 
Thanks millions,


John Spencer said:
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
..
Click to expand...
 
Back
Top