text box #error

[trainsteve]

I am having a problem with a report, i keep getting this "#error"

I have a report that runs off a query that brings back a list of people who
have received a nomination for recognition and part of that I have included a
text box that states whether or not that person has recieved any "ecards".
This is sorted by month.

If in a given month, someone has received a nomination and an "ecard" it
works fine.
If someone has received a nomination, but no "ecard" it stills works fine.
If someone has not received a nomination, the report comes up empty like it
should, but the "ecard" section has "#error"

Here is the code that I have in the text box currently:
=IIf([EcardCount],[EcardCount],"None")

What am I doing wrong and how can I fix this??
Thanks.

 

[Golfinray]

An IIF statement has to be arrainged like this: IIF(expression, what to do if
true, what to do if false) You have no expression. Try IIF([ecardcount]>0,
[ecardcount],["none"])