#Error

[integritycare]

Hi

How do you write the code for a currency text box when using "sum"
on a text box named InvTotal: on the Control Source

=sum([InvTotal])

 

[dhookom]

You can't Sum() a text box. You can Sum() an expression based on the fields in the report's record source. For instance if the control source of InvTotal is:

=[Qty]*[UnitPrice]

You could use a text box in a report or group header or footer like:

=Sum([Qty]*[UnitPrice])

Duane
Hook'D on Access
MS Access MVP