Grand Total on a Continuous Form

[Guest]

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

 

[Guest]

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])
=========================================

 

[Guest]

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

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

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

 

[Guest]

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

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

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

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