Totals across Rows in Report

[SpdRacerX]

I have created a report from 4 different queries to count instances of times exceeded. The report has columns across [<6 Hours], [6-24 Hours], [24-48 Hours] and [>48 Hours] broken down by month (all from the queries).



The problem that is occuring is when I created a textbox to total across the row, it would not calculate if there was a Null value in any of the columns. The calculation worked for those months with data in every fields but returned Null if any of the fields were Null.

Any suggestions?

[SpdRacerX]

Same results when I added a Query Expression to sum all the fields.

[Kirsti]

Have you tried using the Nz function? Or an IIf statement to change Nulls to zeros?

[SpdRacerX]

Worked Perfectly! Thank-you!

[Kirsti]

Glad to hear it!