Re: Calculation on Report

I suspect that the field value isn't really $0.00. You have probably
formatted a Null value to display this way. If that is the case, use Nz() in
your equation to change the Null values to 0.

=Nz([rptPMRentRollTab1BaseRent
subreport].[Report].[rentamount],0)+Nz([rptPMRentRollTab2BaseCAM
subreport].[Report].[camamount],0)+Nz([rptPMRentRollTab4BasePtax
subreport].[Report].[PTAXamount],0)+Nz([rptPMRentRollTab6BaseINS
subreport].[Report].[INSamount],0)+Nz([rptPMRentRollOpCostTab
subreport].[Report].[Amount],0)


--
Wayne Morgan
MS Access MVP


"Lori" <Lori@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F2634824-22B0-4AA9-8F2D-DE7489797ABB@xxxxxxxxxxxxxxxx
> 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: Displaying subreports with more than one record
    ... that you have a situation similar to Orders and OrderDetails like Northwind. ... Your main report should display the Order information and the subreport ... > subreports. ...
    (microsoft.public.access.reports)
  • Re: Displaying subreports with more than one record
    ... However, when I view the report for print, it is now repeating some people ... There are several subreports in the report. ... >> display information such as contact information where there is only one ...
    (microsoft.public.access.reports)
  • Re: format question....help!
    ... a report with 4 subreports would be the simplest way to display 4 ... > When you are making a report, you have a header and a detail section. ... > display 4 unrelated sets of information, equipment, labour, materials, ...
    (microsoft.public.access.reports)
  • Re: Displaying subreports with more than one record
    ... I expect your main report has the same level of detail as your subreport. ... It was not repeating or skipping ... There are several subreports in the report. ... >>> display information such as contact information where there is only one ...
    (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)