Can new columns be added to appended table records, how?

[Guest]

I am appending records from one table to another using a form where the id is
entered and used as the criteria in the append and delete queries, but I also
want to add extra columns to the records appended using the form, but the
appended records and the new columns details for the records are going to new
records in the archive table, is there any way to get all the information to
go into one record and instead of two as it is now?

 

[Guest]

Joey,
We might need a little more information (you lost me in the middle). What
is your form based off? (table/query) What table/s are you trying to append
to?

Could you be a little more specific as to what you are looking for?

 

[Rick B]

Not sure what you mean by "add extra columns". Are you saying that the
records you are appending have fields that do not exist in the target table?
If so, I believe you need to fix the table before you append. The two
tables (in general) should have the same structure before you run an append
query. You later say something about adding two records. Again, not really
sure what you mean by that. An append query will take one record in tableA
and add that record to tableB. If you have ten records in tableA that are
selected in the append query, then you will add ten records to tableB.

Post more details and explain your structure a bit more if this does not
answer your question. When you reply, use database terms (records, not rows
and fields, not columns, etc.)

 

[Guest]

This is simular to something that I have done before. Basicaly creating a
duplicate of a table and adding a new field giving the date of the archive.
This is then exported to CD and the archive table deleted.

After copying the table use the 'Alter Table' command in SQL - see help file
ALTER TABLE table {ADD {COLUMN field type[(size)] [NOT NULL] [CONSTRAINT
index] |
CONSTRAINT multifieldindex} |
DROP {COLUMN field I CONSTRAINT indexname} }

hope this helps