sum of fields in a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is an Example of an evaliation sheet

Errors in a Section
Section A Sec. B Sec. C Sec. D Sec. E. -> 80 Section
Employee A 5 2 0 6 4 ..
Employee B 3 4 5 4 0 ..
Employee C 2 6 7 1 0 ..

I have one Form per Employee and need to know the total of Errors in all sections. With over 80 sections, it did not work using the expression builder. nNo result was displayed in the query. Perhaps there is a way to group these Sections with one step instead of adding them up manually in the Expression Builder.
 
Here is an Example of an evaliation sheet:

Errors in a Section:
Section A Sec. B Sec. C Sec. D Sec. E. -> 80 Sections
Employee A 5 2 0 6 4 ...
Employee B 3 4 5 4 0 ...
Employee C 2 6 7 1 0 ...

I have one Form per Employee and need to know the total of Errors in all sections. With over 80 sections, it did not work using the expression builder. nNo result was displayed in the query. Perhaps there is a way to group these Sections with one step instead of adding them up manually in the Expression Builder.
Click to expand...

Having your data CORRECTLY STRUCTURED would make this a heck of a lot
easier:

SectionErrors
EmployeeID
SectionID
ErrorCount

with records like

EmployeeA; SectionA; 5
EmployeeA; SectionB, 2
EmployeeA; SectionC; 0
....
EmployeeB; SectionA; 3
....

would let you do a simple Totals query - or even a Crosstab query to
regenerate this spreadsheet.
 
Back
Top