Search results

Thank you - I will investigate further. It is a simple report where the numbers are catched from a database and the code put directly in the report. All the other data are correct only 0 or Null makes problems.

This code should be correct: =IIF( [Felt-2] <> 0, ([Felt-1]-[Felt-2])/[Felt-2]), 0 ) but Acces say wrong (;) or ( ) or (,) or [ ] can somebody see where the error is? or is it not possible to make this code thankful for help

Thank you arnelpg - this is exactly as I thougt an have tried this multipel times, but get error from my access Do you know any other way around to replace #errors with blank for the whole database?

sorry not working as I said in my threads.

Good logical solution, but my Access 2016 does not accept your command. The error message is an invalid indicator or parentheses after constants Zero. I have tried various changes without success. Also instead of <> 0 Is Not Null. The next problem is that both [Field-1] and [Field-2] can be...

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...