Append record to another table

J

John

Hi,
Using access 2007, How do i append a record from one table to another?
I have created an Append query but get an error message. "An INSERT INTO
query cannot contain a multi-valued field"
The record obviously has relationships.

I am trying to create an archive system so when a record is no longer
required in the main table it is appended to the archive table.
If I am going about this the wrong way please help me out.

Best Regards

John
 

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

Appending all records 3
Append to table 4
Using an append query in a subform 1
Append Query from Event 'After Update' 1
append query adding all records to table instead of one 8
Add new records into source table on Form 8
Append filtered records to table 1
Append Query Issue 0

Top