Grand Total on a Continuous Form

T

Tracy

Using a Continuous View Form, I have a "Sum Field" which has a calculation
(quantity x price). In the footer I want a "Grand Total Field". I can not get
it to Sum more than one row. I can use =sum field and get the amount of the
first line but after that it is nothing. Any help with this probelm would be
greatly appreciated

Tracy
 
O

Ofer

In the continous form, the grand total field should include the formula

If the fieldName in the form, named "FieldName" , and has =[Field1]+[Field2]
in the control source
The Grand total field should look like
=Sum([Field1]+[Field2])

And not
=Sum([Fieldname])
=========================================
 
T

Tracy

Thanks for your reply. I only have one "Field Name". I am trying to add the
column containing the one "Field Name"

Ofer said:
In the continous form, the grand total field should include the formula

If the fieldName in the form, named "FieldName" , and has =[Field1]+[Field2]
in the control source
The Grand total field should look like
=Sum([Field1]+[Field2])

And not
=Sum([Fieldname])
=========================================
--
I hope that helped
Good luck


Tracy said:
Using a Continuous View Form, I have a "Sum Field" which has a calculation
(quantity x price). In the footer I want a "Grand Total Field". I can not get
it to Sum more than one row. I can use =sum field and get the amount of the
first line but after that it is nothing. Any help with this probelm would be
greatly appreciated

Tracy
Click to expand...
Click to expand...
 
O

Ofer

In that case, the sum should include the name of the field in the table and
not in the form
=Sum([NameOfFieldInTheTable])

--
I hope that helped
Good luck


Tracy said:
Thanks for your reply. I only have one "Field Name". I am trying to add the
column containing the one "Field Name"

Ofer said:
In the continous form, the grand total field should include the formula

If the fieldName in the form, named "FieldName" , and has =[Field1]+[Field2]
in the control source
The Grand total field should look like
=Sum([Field1]+[Field2])

And not
=Sum([Fieldname])
=========================================
--
I hope that helped
Good luck


Tracy said:
Using a Continuous View Form, I have a "Sum Field" which has a calculation
(quantity x price). In the footer I want a "Grand Total Field". I can not get
it to Sum more than one row. I can use =sum field and get the amount of the
first line but after that it is nothing. Any help with this probelm would be
greatly appreciated

Tracy
Click to expand...
Click to expand...
Click to expand...
 
Top