Summing an unbound textbox

K

Ken D.

I am attempting to sum an unbound textbox with the follow syntax:

=Sum([TotalRev])

where [TotalRev] is the name of the textbox. Here is the syntax used in the
[TotalRev] textbox:

=IIf([MonOrder]=104,"73,347",IIf([MonOrder]=204,"91,819",IIf([MonOrder]=304,"106,584",[SumOfGain/Loss])))

What am I missing?
 
D

DebbieG

Where is the unbound textbox located ... Report Footer?


|I am attempting to sum an unbound textbox with the follow syntax:
|
| =Sum([TotalRev])
|
| where [TotalRev] is the name of the textbox. Here is the syntax used in the
| [TotalRev] textbox:
|
|
=IIf([MonOrder]=104,"73,347",IIf([MonOrder]=204,"91,819",IIf([MonOrder]=304,"106,584",[SumOfGain/Loss])))
|
| What am I missing?
 
K

Ken D.

Debbie,

The unbound textbox is located in the report detail. Trying to sum in a
group footer.
 
Top