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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF Statement with 2 Criteria 5
Totals with Condition 3
Problem Sum Code 1
Need help with an Iif expression 3
IIF statement help 13
Problem with IIf statement in report 1
Show phrase when no data for a report 2
how to reference subreport in an If-Else statement (or IIF) 1

Back
Top