J
John Ortt
Hi everyone
I have a query which depending on the users selection may or may-not return
any results.
The expression below works fine when results are returned but when there are
no records it returns '#Error':
=IIf([expirydays]<1,"expired " & Abs([expirydays]) & " days ago")
Is there a way to modify it to gracefully fall over (ie be blank) when there
are no records?
I have tried 'IIf([expirydays] is null,null' and
'IIf(len([expirydays])<1,null' but neither worked.
Thanks in advance,
John
I have a query which depending on the users selection may or may-not return
any results.
The expression below works fine when results are returned but when there are
no records it returns '#Error':
=IIf([expirydays]<1,"expired " & Abs([expirydays]) & " days ago")
Is there a way to modify it to gracefully fall over (ie be blank) when there
are no records?
I have tried 'IIf([expirydays] is null,null' and
'IIf(len([expirydays])<1,null' but neither worked.
Thanks in advance,
John