Count of Certain Values In a Field

[tsn.s]

Hi. I am trying to get a totals column of a field called 'withdrawn_type'. This field can have two different values in it which are 'On Programme' and 'No Show'. I only want to count how many 'No Show' Values there are but I cant seem to get it to work. This is what I have: No Show: Sum(IIf([withdrawn_type]="No Show",0))

[JoeM]

Note that the IIF statement has three arguments (condition, what to return if True, what to return if False). You only have two.
Maybe
Sum(IIf([withdrawn_type]="No Show",1,0))

[tsn.s]

Thanks for the help JoeM. Unfortunately it did not work. A dialogue box pops up when a run the query asking what value I want in the field. If I put 'No Show' in the box it comes back with numbers that a way out.

[JoeM]

Have you placed criteria on this field in your underlying query?
If not, and a dialogue box is asking you to enter a value for [withdrawn_type], it usually means that it does not recognize that field name (you may have a typo in your field name or are trying to use a field which isn't in your report).

[tsn.s]

It's working now. There was a typo in my field name. It was actually called [withdraw_type] not [withdrawn_type]. Can't believe I didn't notice that! Thanks for your help, it's much appreciated.