Extracting from a query!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
..
 
Back
Top