A SHARP COOKIE
  • Home
  • Contact
  • Cookie Crumbs
  • OCO Files
  • Home
  • The Adjunct Files

Adventures In Technology

Joining Two Columns in an Access Table

1/24/2018

0 Comments

 
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.

    Author

    Teacher, Writer, Editor, Instructional Designer.

    Archives

    June 2021
    May 2021
    April 2021
    September 2020
    November 2019
    February 2018
    January 2018

    Categories

    All
    Access
    Accessibility
    Camtasia
    Canvas
    Design
    Excel
    Google Suite
    Microsoft Office
    Power Point
    Stream
    Technology Tips
    Word
    Zoom

    RSS Feed

Services

Tech Training
Content Writing
Editing
Formatting
Publishing

Company

A Sharp Cookie

Support

Contact
FAQ
Terms of Use
© COPYRIGHT 2015. ALL RIGHTS RESERVED.
  • Home
  • Contact
  • Cookie Crumbs
  • OCO Files
  • Home
  • The Adjunct Files