Report Calculated Fields give Errors, need to eliminate 1

[CptCrusty1]

I have a report that merely calculates the values of the fields above it. The problem is in the case where there are no values. I get an error becuase it is trying to calculate a null. I've tried several functions (isnull()) etc, trying to eliminate the error and place a Zero in it's place with no success. Any tips/triks etc?

I live to work and I work to live.

 

[Golom]

Try the NZ function as in

NZ([SomeField],0)

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[CptCrusty1]

DUH!!!!! I COMPLETELY FORGOT ABOUT THAT LITTLE GUY.....UGH! I FEEL SO Stoooooooooopid!!!!

Thanks Dude....



I live to work and I work to live.