append query with one extra column

[SSDA]

hi dears
this is my first time in with you..
and i have one question:

i have "form1" contain data for "table1"

i want to append the current record from "table1" to "table2"

but the problem is ...the "table2" has one column extra and i need to fill this extra column by "any data"?

so any one help me?

thanks and regards

[Rabbit]

Why are you making a copy of the data? Usually that's bad design.

[SSDA]

at first ...thanks for reply;
the goal is to move this record from one table to another one ...
so i will delete it from table1 after copy

regards

[Rabbit]

But why separate the data like that? Again, that's usually not a good design. To answer your original question though, just add an extra field with a default value to your append query

[SSDA]

thank you MR. rabbit
the DB was already existing ... and i just want to do a simple modification on it ... but after your note i will re design it


thanks again