IsError not workin

Hi Guys

I had this in a query
Comment: Replace([Comments],"- Old result was","/")
which is giving me #Error when [Comments] is NUll
i changed to
Comment: iif(IsError(Replace([Comments],"- Old result was","/")),NULL,Replace([Comments],"- Old result was","/")))
BUt still gives me #Error where [Comments] is null
Who is Participating?
titorober23Connect With a Mentor Author Commented:
I just fixed, i changed to
Comment: Replace(nz([Comments]),"- Old result was","/")

Now instead of #Error gives me Null/Blank
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.