multiple queries combined in one table

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

 

[Tom Ellison]

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.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[John Vinson]

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.

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.