Show me an error

[azhar2006]

Hello all



In this function, why
Possible help
= SUM ([SPGR] + [RVB] + [COPPER] + [TESTC])

[June7]

Don't understand.

Exactly what is the issue?

[azhar2006]

Thank you June7
Collecting a set number fields
For example
Total record fields appear in green field
Question
Total column green

[June7]

The expression in original post looks fine.

Are the subforms in datasheet view?

Forms must be in single or continuous view to have textboxes with aggregate calcs because they must be in header or footer section.

If form is in datasheet view, with form open in datasheet not design, click into the subform then click the Totals button on ribbon Home tab. This will open a totals row at bottom of the subform. Select the desired calc.