Form Footer & =sum([field])

[Guest]

I have a main, which has a subform. The subform is a continuous form. In
the footer of the form, i wish to have totals of the fields in the footer.
My formula is =sum([DetailField]), however, the footer calculations display
#Error. What is wrong?. Thanks.

 

[Tom Ross]

I have a main, which has a subform. The subform is a continuous form. In
the footer of the form, i wish to have totals of the fields in the footer.
My formula is =sum([DetailField]), however, the footer calculations display
#Error. What is wrong?. Thanks.

 

[Tom Ross]

Is your formula in the footer of your subform or the footer of your main
form? It should be in the footer of the subform and that control can be
referenced fromthe main form.

 

[Guest]

The formulas are in the footer of the subform. I remove the =sum() from the
control source, leaving =[DetailField], the field displays the first value in
the detail of the field. However, I need to total this field for the
recordset. Applying =sum([DetailField]) produces the error.

Is your formula in the footer of your subform or the footer of your main
form? It should be in the footer of the subform and that control can be
referenced fromthe main form.

I have a main, which has a subform. The subform is a continuous form. In
the footer of the form, i wish to have totals of the fields in the footer.
My formula is =sum([DetailField]), however, the footer calculations display
#Error. What is wrong?. Thanks.

 

[Tom Ross]

Next question

Does [Detailfield] refer to the name of the control source or the name of
the underlying field?

As I remember the sum() must be from the underyling field name in the table
or query. Not the name of the control

Hope this helps. I'm watching too to see if anybody else has a solution.

Tom

The formulas are in the footer of the subform. I remove the =sum() from the
control source, leaving =[DetailField], the field displays the first value in
the detail of the field. However, I need to total this field for the
recordset. Applying =sum([DetailField]) produces the error.

Is your formula in the footer of your subform or the footer of your main
form? It should be in the footer of the subform and that control can be
referenced fromthe main form.

I have a main, which has a subform. The subform is a continuous form. In
the footer of the form, i wish to have totals of the fields in the footer.
My formula is =sum([DetailField]), however, the footer calculations display
#Error. What is wrong?. Thanks.

 

[Guest]

I have tried both to no avail.

Next question

Does [Detailfield] refer to the name of the control source or the name of
the underlying field?

As I remember the sum() must be from the underyling field name in the table
or query. Not the name of the control

Hope this helps. I'm watching too to see if anybody else has a solution.

Tom

The formulas are in the footer of the subform. I remove the =sum() from the
control source, leaving =[DetailField], the field displays the first value in
the detail of the field. However, I need to total this field for the
recordset. Applying =sum([DetailField]) produces the error.

Is your formula in the footer of your subform or the footer of your main
form? It should be in the footer of the subform and that control can be
referenced fromthe main form.


I have a main, which has a subform. The subform is a continuous form. In
the footer of the form, i wish to have totals of the fields in the footer.
My formula is =sum([DetailField]), however, the footer calculations
display
#Error. What is wrong?. Thanks.

 

[Guest]

I had a field that totalled all detail fields. It had a syntax error in it.
All calculated fields in the footer displayed errors until it was fixed. How
odd that the other fields displayed #error. Thanks for your help, Tom.

Next question

Does [Detailfield] refer to the name of the control source or the name of
the underlying field?

As I remember the sum() must be from the underyling field name in the table
or query. Not the name of the control

Hope this helps. I'm watching too to see if anybody else has a solution.

Tom

The formulas are in the footer of the subform. I remove the =sum() from the
control source, leaving =[DetailField], the field displays the first value in
the detail of the field. However, I need to total this field for the
recordset. Applying =sum([DetailField]) produces the error.

Is your formula in the footer of your subform or the footer of your main
form? It should be in the footer of the subform and that control can be
referenced fromthe main form.


I have a main, which has a subform. The subform is a continuous form. In
the footer of the form, i wish to have totals of the fields in the footer.
My formula is =sum([DetailField]), however, the footer calculations
display
#Error. What is wrong?. Thanks.

 

[Tom Ross]

Odd indeed. But then again it's a computer.

I had a field that totalled all detail fields. It had a syntax error in it.
All calculated fields in the footer displayed errors until it was fixed. How
odd that the other fields displayed #error. Thanks for your help, Tom.

Next question

Does [Detailfield] refer to the name of the control source or the name of
the underlying field?

As I remember the sum() must be from the underyling field name in the table
or query. Not the name of the control

Hope this helps. I'm watching too to see if anybody else has a solution.

Tom

The formulas are in the footer of the subform. I remove the =sum()

from
the

control source, leaving =[DetailField], the field displays the first

value
in

the detail of the field. However, I need to total this field for the
recordset. Applying =sum([DetailField]) produces the error.


:

Is your formula in the footer of your subform or the footer of your main
form? It should be in the footer of the subform and that control can be
referenced fromthe main form.


I have a main, which has a subform. The subform is a continuous

form.
In

the footer of the form, i wish to have totals of the fields in the footer.
My formula is =sum([DetailField]), however, the footer calculations
display
#Error. What is wrong?. Thanks.