IIF Statement

[Brennan]

Hello:

I am using the following statement on a report control:

=Sum(IIF([tblBids_Status]="GC-Awarded CMR Awarded",
[txtTotalSum],0))

When I attempt to run the report, I get the following
error:

The Microsoft Jet database engine does not
recognize '[txtTotalSum]' as a valid field name or
expression.

I have triple checked the name of the referenced control
and it is correct. The exact same statement works fine on
several other controls on the reports

Any comments would be appreciated.

Brennan

 

[Duane Hookom]

Is txtTotalSum in the same section of the report? If not, you may need to
substitute the control source of txtTotalSum.