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
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.
Leave a Reply.
Teacher, Writer, Editor, Instructional Designer.