MAKE-TABLR FROM UNION QUERY

[Guest]

Hi Guys,

I have two problems with the task that is killing me.

1. How do I ensure that a union query displays its result in the order that
it was built? I made a union query from many tables and queries, carefully
placing the unions in a particular order, only to find that the results were
displayed alphabetically. I had intended similar items to be next to each
other.

2. Secondly, I want the results of my union query (which is essentially a
foundation for what auditors and accountants refer to as TRIAL BALANCE)
stored in a table where future records will also be added, such records that
can be retrieved at will. My poor understanding of a make-table query however
suggests that a new table will be created each time I run the query. Is there
a way to have only one table for all records, provided of course that each
set of records is properly identified for easy retrieval in future? The
numerous fields for the supertable have to come from several tables, and I
would not know in advance what users would have put there.

 

[[MVP] S.Clark]

1. Sort order is determined by the Order By clause in the query. Change it
as needed OR give the data in each table a unique number, then sort by that
column.
e.g.

Select *, 1 as Sort from t1
UNION
Select *, 2 as Sort from t2
ORDER BY Sort

2. Using a Delete and Append query, instead of the Make Table.

 

[Guest]

Thank you Clark, I will give it a shot right away.