How do you SUM a textbox that has the control Source as =[PartsSupplierWSP]*[SOH]?

[Lateral]

Hi guys

I am putting together a pretty simple report based upon a Table called "Parts". This contains a list of parts in the Stock and Inventory and includes the following field:

SOH - Stock on Hand
Wholesale - Wholesale (Cost) price in AUD
PartsSupplierWSP - Wholesale (Cost) price in USD

and a few more.

I want to calculate the value of the SOH based upon the Wholesale and the PartsSupplierWSP values.

I have created an unbound Text box called [ValueofSOH(USD)] and have the Control Source set to the following:

=[PartsSupplierWSP]*[SOH]

This calculates the value correctly.

Now what I want to do is to SUM the entire column so that I can get a total value of all stock.

It doesn't let me SUM and only lets me Count on these "Calculated" fields.....how can I sum these columns?

Thanks for your help.

Cheers
Greg

 

[Ranman256]

Create a query, add this calculation to the QUERY.
Bind the text box to this field.
At the form footer, add an unbound field, =sum(txtBox)

 

[pbaldy]

Just so you know you can also do:

=Sum([PartsSupplierWSP]*[SOH])

 

[Lateral]

Thanks guys!

Solved!

 

[pbaldy]

For the record, my first choice would be the query route, just wanted to make sure the other got mentioned in case changing the query wasn't an option.

 

[Lateral]

Thanks Paul,

I went the Query route...