Access query generator

chestera
chestera used Ask the Experts™
on
Hi EE
In the Access query generator I am trying IIF statment but having a mental block with the use of Not Isnull.

Com:iif(Not Isnull([Comments],[Comments],"No Comments"))

I have tried various combinations Is Not Null. IsNull etc. So simple but can't get it right. The error occurs with the Not null section

chestera
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Solutions Consultant
Commented:
Cannot test right now but I think the problem here is that IsNull is a function and so you need to use brackets around the test

try

iif(Not Isnull([Comments]),[Comments],"No Comments")

Open in new window

Author

Commented:
Michael74

Thank you Michael as soon as I looked at your solution it came back to me.Yep it works.

Alan

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial