How do I copy One Drive Files?
This is a frequently asked question when I do training, because One Drive options are contextual - they show up based on your actions. So to see the button to select files to copy, you have to position your mouse to the left of the file.
Once you click the circle next to the file, a whole world of options opens on the top menu and you can click on copy files - but you have to click copy to see the drive option. From there, you will see the folders and select copy.
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.