multiple queries combined in one table

  • Thread starter Thread starter D Schmidt
  • Start date Start date
D

D Schmidt

am looking for the recipe to dump, copy, send, append or
whatever other function it may take to place query data
with from multiple queries with identical fields but
differing data and place their data into a single table.
 
Dear David:

It sounds like you would want to build a UNION query out of the
separate queries into one query. Then you can base an append query on
that.

Don't forget that you may have to fight with duplicates in any sets of
unique columns.

am looking for the recipe to dump, copy, send, append or
whatever other function it may take to place query data
with from multiple queries with identical fields but
differing data and place their data into a single table.
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
am looking for the recipe to dump, copy, send, append or
whatever other function it may take to place query data
with from multiple queries with identical fields but
differing data and place their data into a single table.
Click to expand...

Either change all the queries to APPEND queries and run them in
succession; or create a UNION query combining all the individual
queries, and base an Append query on that UNION query. See the online
help for UNION.
 
Back
Top