Calculation on Report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello, I have a main report and several subreports. I am calculating a field
from each one of these subreports into an unbound text box on the main report.

=[rptPMRentRollTab1BaseRent
subreport].[Report].[rentamount]+[rptPMRentRollTab2BaseCAM
subreport].[Report].[camamount]+[rptPMRentRollTab4BasePtax
subreport].[Report].[PTAXamount]+[rptPMRentRollTab6BaseINS
subreport].[Report].[INSamount]+[rptPMRentRollOpCostTab
subreport].[Report].[Amount]

It works on those files where there is a dollar amount in the field. But
when the field is $0.00, then this returns "#Error". Any suggestions?
--
Thank, Lori
.

Relevant Pages

  • Re: Too Many Fields Defined
    ... One option is to split the report into reports with separate queries. ... Are there other work arounds? ... Two subreports on one (unbound) report, ...
    (microsoft.public.access.queries)
  • Re: Multiple reports on one
    ... Try using a Report (unbound) with two Subreports (one bound to each ... John W. Vinson/MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: Calculation on Report
    ... I am calculating a field ... >from each one of these subreports into an unbound text box on the main report. ... You will also get the error if the subreport ...
    (microsoft.public.access.reports)
  • RE: bind subreports during runtime
    ... Forthermore a lot of plugin-components are exsting. ... of a framework- report. ... I received an exception "Not supported within subreports" ... Eine existierende Framework-Komponente soll Report- Funktionalität anbieten ...
    (microsoft.public.vb.crystal)
  • RE: bind subreports during runtime
    ... Forthermore a lot of plugin-components are exsting. ... of a framework- report. ... I received an exception "Not supported within subreports" ... Eine existierende Framework-Komponente soll Report- Funktionalität anbieten ...
    (microsoft.public.vb.crystal)