Forms Calculations 1

[TimTDP]

In Access 2000 I have a form in which each record has the fields "Units", "UnitPrice" and a control called "TotalPrice".
The control is the formulae "Units" * "UnitPrice"
In the forms footer I have a control "InvoiceValue" which should be the sum of "TotalPrice"
I have tried setting the control of "InvoiceValue" to =Sum([TotalPrice]) or =sum([Units] * [UnitPrice]) but keep getting an error.
What is the correct syntax?

 

[Glohamar]

Is this a sub-form on another form? Are you using the datasheet mode or continuous mode on a sub-form and then a main form that is totaling items from the sub-form?
Dave

 

[MajP]

see if this helps.
thread702-1394345

 

[TimTDP]

Hi Dave
It is not a subform. The form is continuous mode

 

[Remou]

TimTDP
I have found that, with these Sums, if one returns an error, all will return an error in an odd and troublesome way. If you have several experimental additions, delete them, and try something simple:

[tt]=Sum([Units])[/tt]

If that works,

[tt]=Sum([Units] * [UnitPrice])[/tt]

Should work.