Total for Row

[kwooten]

How do I total for a row in a report? I need to add each group... The data is in a footer while the details are "not visible".

[pbaldy]

If you're saying you want to total the recruiter group, you'd have to add them:

[Field1] + [Field2] + [Field3]...

[kwooten]

I want, "Associate 38"... After "121 & Higher" I want "Total Positions" then under that the sum of each group so Associate would be 38.

Is that possible?

[pbaldy]

Sure, using the method I mentioned. The Sum() function works across records, not fields.

[kwooten]

This is my design sheet...

[pbaldy]

And?

Since it appears you have sums in the others, you either need to add the textboxes or add the summed fields, like:

=Sum(Field1) + Sum(Field2) ...

[kwooten]

I summed it based off a unique identifier and it worked like a charm.

Thanks for your help.

[pbaldy]

Happy to help.