nz function problem-query to form

[southbender]

I am using the nz function in my queries. The function works at that level.
However, when I try to open the form it won't allow me to. If I take out the
nz function everything works fine.

Any suggestions

 

[Allen Browne]

Could be an issue with the data type. Try an IIf() expression instead.

More details and example:
http://allenbrowne.com/QueryPerfIssue.html#Nz