=Sum([Units]*[LastCost]) HELP

[JCross]

morning everyone. i have the following in a text box as a total..

=Sum([Units]*[LastCost])

which works just fine. but i need the sum to be (Units*LastCost) divided by Yield. I keep on getting error#, and i don't know why. the Yield is in the query for the form, though not displayed on the form.

i tried =Sum([Units]*[LastCost]/[Yield])

to no avail.

thank you!!

Jennifer

[This message has been edited by JCross (edited 03-19-2002).]

 

[cliff7376]

have you tried
=Sum(([Units]*[LastCost])/[Yield])

 

[JCross]

Thank you! Worked perfectly.

Jennifer

 

[cliff7376]

no prob