Counting a Value in a Dropdown Field

[stew561]

Say I have a simple report that is based off a query.

The report looks like this

[Name] [Result]
Stewart Sold
Steve Pending
David Sold
Shelly Sold

The [Result] Field is a dropdown list where the user can choose either "Pending" or "Sold".

I want to find out how many "Sold" are there, so I do the following:

=Count(IIF([Result]="Sold",0)) But I keep getting an error stating that its may be to complex or the syntax is wrong. Why is it hard to do a count based off a value in a drop down list?

 

[boblarson]

You have to give it both what to do when true and when false. The syntax for an IIF statement is IIF(expression,value if true, value if false).
So, you should modify to read:

=Count(IIF([Result]="Sold", 1, 0))