cheloto
New member
- Local time
- Today, 09:12
- Joined
- Apr 26, 2021
- Messages
- 6
how do i replace "#num!" and "#div/0!" with blanks in my reports?
example:
=([field-1]-[field-2])/[field-2]) empty not #num or #div
where field-1 and field-2 is 0 or empty not #Num! and field-1 is 0 and field-2 is 5 not #Div
=Nz([field-1]-[field-2])/[field-2]);» «) is not working.
Thankful if anyone can see a solution
example:
=([field-1]-[field-2])/[field-2]) empty not #num or #div
where field-1 and field-2 is 0 or empty not #Num! and field-1 is 0 and field-2 is 5 not #Div
=Nz([field-1]-[field-2])/[field-2]);» «) is not working.
Thankful if anyone can see a solution