Adding an Employees Data into a "Total" column (1 Viewer)

Hi all,

I was wondering if it were possible to make a calculated field or a query that will take all of an employees certain record and sum them all into a total that will be its own column.

For instance Employee 1 is working on Project 1 and Project 2 both with a 50% dedication of service to each project. Employee 1's Total column should add to 100%.

Employee 2 works on Projects 1, 2, and 3 with a 25%, 25%, and 20% dedication of service respectively which would mean their total column would say 70.

Is this possible, and if so what is the right course of action?

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.

Hi. If you have separate records for each employee/project combination, then this should be possible using a Totals query.