make table query

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

 

[Chris M]

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

 

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