Add records to table

[Jim]

I would like to use existing data in tables and use this information to add data to another table. Is there a simple way or do I need to learn visual basic?

 

[Naresh Nichani MVP]

Hi:

Try using a Append Query. Create a new query and in Design View add the
table you want to Append from Then click Query | Append Query on menu and
select the Table you want to Append to. Then select the fields in table to
append and corresponding field in table to append. Save the Query and run.
You cannot run this query from the Query Design window -- it needs to be run
from the database window to actually execute.

Regards,

Naresh Nichani
Microsoft Access MVP

I would like to use existing data in tables and use this information to

add data to another table. Is there a simple way or do I need to learn
visual basic?