IIF Statement

  • Thread starter Thread starter Brennan
  • Start date Start date
B

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
 
Is txtTotalSum in the same section of the report? If not, you may need to
substitute the control source of txtTotalSum.
 
Back
Top