append data and modify own table

[sachin123]

i need to append data to another table, but at the same time i need to modify the current table.

Table "seats" has flight no., seat no. ... and appended

what i want to do is append some of the selected fields to a table called points. but at the same time change the appended field from no to yes

appending the data is fine (using a appen query) but its the modifying its own data that i dont know how to do. any ideas?

thanks
sachin

 

[khawar]

you can use a update query or sql statement to update table

 

[sachin123]

update queries let u update EXISTING records- but thing is i actually need to create a new record on the "points" table and just change the "appended" field from no to yes in a already existing record