Suming a calculated field in subform

[northernbeaver]

I have a form whith a subform. on the subform there are three fields of inportance:

qty : a text field-numeric value that lists the quantity

ItemId : a combo box with three columns (ID;Name;Value)

txtCalculated : a text field with controlsource of =([Qty]*ItemID.column(2))

I want to have a sum of txtCalculated on the footer of the subform so I created text field on the form footer with a control source of =sum(([Qty]*ItemID.column(2))) but I get an error. any ideas?

 

[PETE314]

Is the name of the filed you ar summing txtCalculated?

If so it should read

Sum([txtCalculated])

I would probably add a an Nz function for null sets

Nz(Sum([txtCalculated]),0)

I would also make sure that the format property for txtCalculated was set to the correct number type...such as currency or General Number.....