G
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.
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.