Crosstab values remain null

[Zeroanarchy]

Hi, was wondering if someone can see what I am doing wrong.

For some reason the values in the fields remain blank even when they are told to change to No

TRANSFORM First(IIf(IsNull([LPRODUCTNAME])=True,"NO","YES"))

ZeroAnarchy
Experience is a wonderful thing. It enables you to recognize a mistake
when you make it again.

 

[dhookom]

Try:
TRANSFORM Nz(First(IIf(IsNull([LPRODUCTNAME]),"NO","YES")),"NO")


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Or this ?
TRANSFORM First(IIf(Trim([LPRODUCTNAME] & "")="","NO","YES"))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Zeroanarchy]

Thanks both of you,

PHV the method you mentioned did not work, but the method dhookom mentioned did work. I don't understand why?

Thanks again.

Cheers

ZeroAnarchy
Experience is a wonderful thing. It enables you to recognize a mistake
when you make it again.

 

[dhookom]

Mine suggestion was a WAG. The Nz() around the outside generally works to place a value where none exists.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]