I have two tables in Access that I want to join together to help sort information for Quarterly Reports. One way is to run a query, but another way is to use the calculated data type in the table.
Since I don't want to have to run an append query multiple times a day, I decided to use the calculation feature. I may regret having done this instead of a query, but for anyone else who wants to combine two columns in the same table: In Design View: Name the Field Choose Calculated In Expression [Name of Column1] & [Name of Column 2]. Obviously if you have a space, add in &" " after the first [Name of Column]. It works, but it was so simple that I am suspicious. Access is never simple for me. I am using Access 2016, btw.
0 Comments
Leave a Reply. |
AuthorTeacher, Writer, Editor, Instructional Designer. Archives
June 2021
Categories
All
|