Append Query in MS Access

[D. Taylor]

Hello everyone! I am working on a project and have two obstacles I
cannot seem to figure out. First, I have a database which contains
email addresses, order amounts, etc in Table A. I am de-duping these
email addresses against other information, so many of the records will
be deleted, therefore in order to keep the integrity of Table A, I
have a make table query running which essientially copies Table A,
creating Table B. Table B is our temp table. I have another temp
table, Table C which I would like to append to Table B. The problem I
have is that I cannot seem to choose append to Table B as an option
when trying to write the query. Is this because Table B is created
from a make table query? Obviously, I made sure to make the table
before I tried to write this append query, but it is still not an
option to append Table C information to.


Second question. I have to update several queries in this database
with the same survey ID in the survey ID field of each query. Is
there any type of update query that can be written that will prompt
the user for the survey ID and then automatically change all survey
ID's to the user entered value?

Thank you VERY much for your help everyone!

D. Taylor

 

[KARL DEWEY]

Is this because Table B is created from a make table query? No.
What error message are you getting? What is the indications? Check your
typing.
NOTE - Your must open forn, enter data in list box, keep form open,
and then run query.