Calculated fields

[smanuel]

Here is a description of the situation.

I have a sub form that i need 2 calculated fields on. The first is calculated from the quantity and the cost of the record and is in the details section of the form. I have this one working fine. The second one is in the form footer and must do a sum of the first calculated field. I can't get this one to work.

Calculated field 1: Name: Item_Total
Control Source: =[Quantity]*[Cost]

Calculated Field 2: Name: Total
Control Source: ? (tried =Sum([Item_Total])

Thanks for any help

 

[DougP]

try moving it to the Report footer
Also make sure the "name" of it is not a field name in the underlying table DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[smanuel]

both of the fields are on the same report. one is in the details section (the quantity * cost) and i need the one in the footer to make a sum of the one in the details section.

 

[smanuel]

sorry, that should read the same form...