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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to display highest totals 1
Extract info from Multiple Tables & combine into 1 1
Extract data from three tables 0
Trying to make a query that's based on a variable table name 2
Query with common fields to all records 6
Parameter in Qry 2
Monthly Query 2
Make Table Query-Access 2007 2

Back
Top