What is the most efficient (ie easiest for me) way to copy a record
from an existing table, appending it to that same table but
incrementing a field's value? (code is fine)

Cheers very muchly
Bruce

Bruce wrote:
An append query will work. In the column to inc the value, enter +1
after the field name.

Be sure you set the WHERE criteria to filter the record to be appended.
For example, if you wanted Smith record, enter Smith in the criteria
row for the LastName field.