J
Jeff
I have the following function in a report:
=Sum(IIf([Race Correct]="N",1,0))/Sum(IIf([Address],1,0))
*100
The problem that I am having is that if Race Correct or
Address Correct is not "N", or Null, it creates a #Num!
message. How do I tell this that if these fields are Y,
to set the value os 0?
Thank you very much
Jeff
=Sum(IIf([Race Correct]="N",1,0))/Sum(IIf([Address],1,0))
*100
The problem that I am having is that if Race Correct or
Address Correct is not "N", or Null, it creates a #Num!
message. How do I tell this that if these fields are Y,
to set the value os 0?
Thank you very much
Jeff