[AccessD] Question on order within a union query

Joe O'Connell joeo at appoli.com
Wed Aug 8 09:19:48 CDT 2007


If you are creating a report, the order of records in a report is not
dependent on the order returned by the query.  It is set in the Sorting
and Grouping settings of the report.

Joe O'Connell

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
ewaldt at gdls.com
Sent: Wednesday, August 08, 2007 9:45 AM
To: accessd at databaseadvisors.com
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
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
imitate it for him within Access. This spreadsheet includes several
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?


Thomas F. Ewald
Stryker Mass Properties
General Dynamics Land Systems

This is an e-mail from General Dynamics Land Systems. It is for the
intended recipient only and may contain confidential and privileged
information.  No one else may read, print, store, copy, forward or act
in reliance on it or its attachments.  If you are not the intended
recipient, please return this message to the sender and delete the
message and any attachments from your computer. Your cooperation is

AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list