Sum in SubReport generates #Error

[mveijndh]

I'm trying to add up the total for individual invoices sent to a client. I've set the subReport to work out the calculation in the report footer as

=SUM(invoicevalue)

The idividual values are correct, the summation gives me back an #Error
Please advise

 

[pbaldy]

If invoicevalue is a calculated control, you can't sum it. You can either sum the calculation or move it to the subreport's source query.

 

[RuralGuy]

To add to Paul's reply, I've also used invisible controls on the Report to keep a running total.

 

[boerbende]

If invoicevalue is the name of the field in a report, this could be the problem. Use the name of the column in the recordset

 

[mveijndh]

InvoiceValue is not a calculated field, it's a table field. I've tried to sum up in the query, but it does not want to do that as well??
It's not the name of the field, it's Tekst14.
How can I use a hidden field to keep the running total??
How can I sum the total of a calculated field, I do have those as well?? I assume I have to do that by VBA. Does this work for a report the same way it does for a Form?? On a form you just run the query and add all records you've found in the set. How does this work on a report??:banghead:

 

[pbaldy]

If you get an error summing a field name, make sure you have it in the report footer rather than the page footer. To sum a calculation made on the report (as opposed to a calculated field in a table) you sum the calculation:

=Sum(Quantity * Price)

or move that calculation out to the query so you can just sum a field.

 

[mveijndh]

I had this in the Page footer, not in the report footer!!

 

[pbaldy]

Glad we found the problem!