Extracting from a query!

[Guest]

I have created three queries based on two tables that I have. However, I need
these three queries to create a new table containing all the data within
these three. I would use a Make Table query but this would replace the data
and I need to add to this data in the new table every month.
If the queries are named a,b and C with matching fields ID and Month, how
would i extract these into a table every month.
Many Thanks,
Matt

 

[Guest]

Update query? Apologies for not giving more details but may give you a start.

 

[John Spencer]

Use an APPEND query. Append queries add records to an existing table.

You should be able to change your existing make table queries to append
queries.
--Open the query
--select Query: Append from the menu
--Select the destination table
--Set up the mapping in the Append To row

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..