Total Sum for report and subreports... 1

[mollow]

Hi,

Wondering if anyone out there can help me with a problem.

I have a report that calculates an invoice. The invoice contains 2 subreports.

I would like to calculate a total sum of these subreports and can easily do so when both subreports contain data. The problem is that occasionally the second subreport will contain no data and consequently i get an #error message in my total sum field.

Anyone have any ideas?

Thanks in advance,

Mike

 

[JoeMiller]

You can check for an error using the IsError function:

=iif(IsError(x+y),x,x+y)

HTH Joe Miller
joe.miller@flotech.net

 

[mollow]

Excellent,

Worked a treat mate, many thanks.

Mike