Count on a drop down box

[baum12]

I need a count - I have a drop down box titled Status with 2 items in it. Funded and Pending. I need a total on my report of each. For example:

Funded Awards = 7
Pending Awards = 6



I was attempting to put a count in the page footer of report, something like this:

=Count([Grant Query]![Status]="Funded")

Not working for me though, any help would be appreciated.

[pbaldy]

Try

=Sum(IIf([Status]="Funded", 1, 0))

[NTC]

PB's advice is almost always right on, but I'm confused in that you post the drop down box and I think PB is summing data in the detail of the report.

if you are counting something that is not in the record source of the report - then what you want to do is go into VBA and in help there take a look at DCount method - it will show you the syntax to use...... give that a try.