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.
AHH! I have been working on a handout and when I copy the words from one page to another, there is a white highlighting. I have marked "no highlight" ... but still, it highlights.
Here is the solution I found.
Choose "Clear Formatting". It removes all the formatting so I had to redo the Heading 2 Style that I was using ... but it worked. It is on the home tab and looks like a little eraser, and in the Styles Pane.
Having been lucky enough to be an Excel Trainer for many years, I can't believe I forgot how to do this and had to look it up!
I was tracking how many different times people attended training, but I wanted Excel to tell me how many people were unique and give a count for each person.
It is under Data - Sort and Filter - Advanced.
Then I had it copy the data to another row and only show unique values. Then I ran a count of the names, and it was done!