Sum not showing up

[sondriven]

I searched in Report forum and couldnt find help, and figured this is a general topic.

I have a report with a subform in it. I want to run a sum of a field in the subform. I made a text box inside the subform footer. And put this expression for the control:

=Sum([Total Cost])

The field box is named Total Cost. When I go to preview the report the Sum text box is empty.

Why is this?

 

[fernin8r]

It usually means that there is a null in your field that it can't add.

If this is the case, try using the Nz() function.

 

[sondriven]

Yes I have Quantity and Unit Cost fields.

In the Total Cost field is the expression:

=[Quantity]*[Unit Cost]

I think what youre telling me is that Access cant take this further and give me a sum of the Totals for a final cost.

Is there any way of doing this? I tried your expressions and they didnt seem to work.

Thanks.

John

 

[sondriven]

Hey Pat,

Of course I didnt try to use your column names. But what was missing was the parenthesis.

Got it to work now. Thanks a mil.

John