Hi All...
I'm appending a data to a table containing primary key for the no.
How can I delete the previous no. and update the new one..
Thanks in advance

If a record already exists for a given primary key, you should use an update query rather than an append query. Append queries only insert NEW rows. They do NOT update existing rows.