Valores nulos

[Guest]

How to get datas with value zero in a consult?
I tried the following but I couldn't use it.
=IIf(Énulo([nomedocampo]),"Desconhecido",Format([nomedocampo],"@;\ZLS")). The
program returned "error or improper use of coma..."

 

[Guest]

The syntax of IIf is this:

IIf(expr, truepart, falsepart)

This has three parts, separated by two commas. Your statement has four
parts, separated by three commas.

 

[John Vinson]

How to get datas with value zero in a consult?
I tried the following but I couldn't use it.
=IIf(Énulo([nomedocampo]),"Desconhecido",Format([nomedocampo],"@;\ZLS")). The
program returned "error or improper use of coma..."

I'm not sure (I don't have the Spanish language version of Access),
but I suspect you need to either consistantly use ; or ,:

=IIf(Énulo([nomedocampo]);"Desconhecido";Format([nomedocampo],"@;\ZLS"))

or

=IIf(Énulo([nomedocampo]),"Desconhecido",Format([nomedocampo],"@,\ZLS"))


John W. Vinson[MVP]