make table query

G

Guest

I having some complication with make table query. I have lots of very complex
query and in a given time access was not able to make all the calculations I
wanted too. So I started making make table query to hold the results of my
queries. My problem is that I want access to keep adding lines in the table
with new results referring to the id key I put in and not erase the table and
make a new one with just one line.
 
C

Chris M

Felipe said:
I having some complication with make table query. I have lots of very
complex
query and in a given time access was not able to make all the calculations
I
wanted too. So I started making make table query to hold the results of my
queries. My problem is that I want access to keep adding lines in the
table
with new results referring to the id key I put in and not erase the table
and
make a new one with just one line.

If you want to ADD rows to your results table, you would be much better off
turning your MAKETABLE query into an APPEND query.

Regards,

ChrisM
 
J

John Vinson

I having some complication with make table query. I have lots of very complex
query and in a given time access was not able to make all the calculations I
wanted too. So I started making make table query to hold the results of my
queries. My problem is that I want access to keep adding lines in the table
with new results referring to the id key I put in and not erase the table and
make a new one with just one line.

A MakeTable query does exactly that: *it makes a new table*. If there
is another table with the same name, you must delete it before the
maketable query will run.

If you want to add new records to an existing table, don't use a
MakeTable query - use an Append query instead. That's what it's for!

John W. Vinson[MVP]
 

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

Top