removing Null values & 0 values before printing

[arage]

My report is coming up with a smattering of #Num! And #Div/0 errors, sometimes both in the same column in my report. I have 3 levels of grouping so far, byDirector, byMediaEndDate & then a grandTotal. These errors appear in all these headers. I’d like to write some code that will format a header’s RECORDSET before it prints & traps & will clear the #Num! & #Div/0! Errors.

Is this possible? There are way too many fields to go in & fix individually in all these headers so would like to attempt a fix on a header wide level, that I could stomach.

 

[The_Doc_Man]

In the report headers, where you have a reference (say [XYZ]) and it comes up with this error, change the report reference to Nz([XYZ],"{text-that-says-it-was-left-blank}") for text fields. You can also use Nz for numerics but would have to supply a different second argument for that case.

 

[arage]

Some of the totals in my column show up as blank & others show #Num! or #Div/0! When I use the suggested NZ( FieldA,0) to remove the errors, the ONLY fields receiving a 0 are the totals that initially were coming up completely blank. My #Num! and #Div/0! Errors have not changed for the other values.

 

[arage]

ok I fixed my problem people, I was improperly filling out my function! Thanks so much!