[AccessD] Question on order within a union query

Tom,

I don't know the "answer," but in my experience I've found
that the first query controls the sort of the union.
(All sorts should be in the QBE of the first query.)

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: <ewaldt at gdls.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, August 08, 2007 9:45 AM
Subject: [AccessD] Question on order within a union query


> I'm converting an Excel workbook to Access, to add functionality and
> better ability for several people to use it at the same time. I've created
> the tables, relationships, etc., with no problem. However, I would like
> suggestions in one area.
>
> The user likes a spreadsheet report in the original workbook. I'd like to
> imitate it for him within Access. This spreadsheet includes several lines
> of data (easily duplicated within Access via query), the columns
> subtotals, two more corresponding rows of data (i.e., the columns
> correspond, but the rows are different), and a final totals line.
>
> I've put together all of the information via queries. I then combine the
> queries via a union query, but it insists on mixing the lines together,
> alphabetically, by the first column/field. I'm looking for a good way to
> avoid this. Is there a key word, command, etc., to tell Access to leave
> things in the order they're found?
>
> If not, do you have recommendations on how to achieve what I want in a
> different way?
>
> TIA.
>
> Thomas F. Ewald
> Stryker Mass Properties
> General Dynamics Land Systems