The Paste Append feature is often overlooked in Access. This feature lets you quickly create new records that copy existing information from other records. To see one way to use the feature, open a table in Datasheet view. While holding down the [Shift] key, select adjacent fields with data you want to copy. You can also select fields from adjacent records. When you've finished, press [Ctrl]C to copy the data. Then, choose Edit/Paste Append and click Yes when Access asks for confirmation. You'll now have an appropriate number of new records in the table that contains the information you copied.

Access Index

Main Index