access training courses - Append Update query

Hi Jigna

The best way to do this is to create an Update Query and run it on the table which contains the data to be appended.

Once the data is updated then run the Append Query.

If you need to do these two actions simultaneously then create a Macro which runs the two queries.

Regards

Carlos