How to Transfer Date Data From One Field to Another in Access

Microsoft Access is software which allows the user to create both simple and intricate databases. It also contains features to make the databases easier to use, allowing you to use queries and forms to sort the information you need to access. You can also use the query function to copy information from one Access field to another, making maintenance of the databases easier.

Instructions

1. Open Access, and the database you wish to use.

2. Click "Query" on the toolbar.

3. Select the option to add your own code to the query. Access 2007 and newer will launch the coding window automatically.

4. Copy the below message into the window.

   Update A1

   Set A1=B2

5. Replace A1 with the name of the field into which you want to copy the data, and B2 with the name of the field from which you are copying.

6. Run the query, and save the database.

Tips & Warnings

• To find the name of the field, read the letter from the left side of the field, and the number from above the field. The name will consist of one letter and one number.

• The field will automatically update if you change the field from which it is copying.

References

• "Microsoft Office Access 2007 Step by Step"; Joan Lambert; 2007.
• "How to Do Everything with Microsoft Office Access 2007"; Virginia Andersen; 2007.