Unusual Calculation in Report Header

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

HI all,

I am trying to sum the total of three fields in the report header. Seems
easy enough and I understand how to do that in a typcial situation. But,
here is my situation. The report is for government compliance, so the report
includes to entirely and unrelated tables. Therefore, I have two subreports.
In the report header, I must show the grand total from each sub report which
I have done. A third field's value is derived from an input box as the
information is arbitrarily supplied from a different department. Now, I need
to sum all three fields. Since you cannot use the Name of the control, I
assumed I would need to completely reference the fields in the final
calculation, but, I only get error messages. Please let me know if this is
even possible. Thanks so much!

The calculations in the report that provide the values for each calculated
control are below:
=FormatCurrency(sbrptDCGiftExpenses.Report!GrandTotalGift)
=FormatCurrency(sbrptDCAdv.Report!GrandTotalAdv)
=FormatCurrency(InputBox("Enter the Aggregate Cost of employees engaged in
promotional activites in the District of Columbia"))
 
Marshall,

Thanks that worked perfectly. I was surprised that the formatcurrency is
translated as text. I feared it was more complex than that...wouldn't you
know.
 
Back
Top