How to Update With Another Column's Data in Access
In the Microsoft Access application, which is part of the Microsoft Office software suite, you can design database queries to output specific information from your tables of information. While making a new query, you have the option of establishing new fields using basic functions. For example, you can use the concatenate function to update a new field with data from another column in the table.
Other People Are Reading
Instructions
-
-
1
Launch the Microsoft Access application and open the database file that you want to use.
-
2
Click the "Create" tab in the toolbar at the top of the window and click on the "Query Design" button.
-
-
3
Highlight the name of the table that contains the fields you want to reference, press the "Add" button and then click "Close."
-
4
Place your cursor next to the "Field" row at the button of the window.
-
5
Enter the name of the first column you want to reference. Access will try to automatically guess the name based on available fields in the database.
-
6
Enter the names of any additional columns you want to reference and separate them by the "&" symbol. This will tell Access to use the concatenate function when updating the field in the query.
-
7
Add text or numbers to your query field by placing them within double quotes.
-
8
Click the "Run" button at the top of the window. Access will now update the query field you created with data from the columns you chose to reference.
-
1
References
- Photo Credit typing image by Dariusz Urbanczyk from Fotolia.com
