Copy a record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bruce - 30 Sep 2004 22:33 GMT

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

Reply to this Message

Salad - 30 Sep 2004 22:48 GMT

> 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

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.

Reply to this Message