Re: Adding an Employees Data into a "Total" column
1. Is it possible? Yes. Queries are the typical way to format, reformat, add, average, or otherwise compute things from tables.
2. Is it the right course of action? Maybe not.
This sounds like you have a normalization issue depending on exactly how you are displaying your employee's project load assignments. If you have not previously done so, please read up on "database normalization" via web search. Initially, confine yourself to reading articles from the .EDU domain as they tend to be more technically correct yet are often written in clear language with minimal jargon.
You can also search this forum for issues of normalization. In this forum's search you don't need to specify "database" since this IS a database forum. For the more general web search, you need to include that qualifier because by itself, "normalization" can apply to math, politics, chemistry, and educational concepts.
If you have fields in your employee record with names like Project1, Project2, Project3, etc. then you have what is called a "repeating group." This is a common occurrence for anyone who used to work with Excel and is now trying to learn Access.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.