Simple Report Total not working... Access 97 1

[WebGuyToo]

Hello, I'm trying to do simple total on an OUTCOME_DESC field thats in a group header. In the group footer I have a text box which is where I'm trying to do the total with a control source of:

[OUTCOME] is the name of the bound field for OUTCOME_DESC

=Sum(IIf([Reports]![ACTIVITY_LOG_RPT].[OUTCOME]='Approved',1,0))

it returns 0 when I know there are 206.

If I try to take out the '' marks around Approved like:

=Sum(IIf([Reports]![ACTIVITY_LOG_RPT].[OUTCOME]=Approved,1,0))

I get ask to Enter Paraneter Value for Approved.

please help any ideas?

 

[glalsop]

Hello WebGuyToo -

Try counting the field, not the control that is bound to the field:

=Sum(IIf([OUTCOME_DESC]='Approved',1,0))

-Gary

 

[WebGuyToo]

That worked perfect.

I had the wrong reference. Thank you for pointing that out.

Thanks again,

WebGuyToo