IIF() #ERROR

[vbjohn]

On this report, which gives a list of checks that were run on a certain day.

On this report I need to have a mark by the checks that were voided out. I tried using IIF statement on the control source on the text field.


=IIf([VOIDED]>0,"*"," ")

Example Output:

* 986365 John 65.60
* 986957 Steve 98.20
986856 John 79.30


Does this make sense?

John-

 

[Ally]

Check your identical post under General. You shouldn't post identical posts under more than one heading. It gets confusing.