Summing Fields in a Continuous Form

Question

Hello,

I have a continuous form and I want to sum the values at the form footer, please see attached image to help explain it.

Could someone please help me out.

Answer 1

Please provide the Control Source of the text box that shows error. What is its name?

What happens if you create a brand new form with the same record source and a single text box in the form footer with a control source of:

=Sum([Total Cost])

Answer 2

Also, is Total Quote a computed control in the form, rather than a computed column in the query?  If the former you should apply the Sum operator to the expression used as the computed control's ControlSource property.  To take a simple example, if a form included a comouted control in its detail section with a ControlSource property:

=[UnitPrice]*[Quantity]

then to sum the values in the footer the expression would be:

=Sum([UnitPrice]*[Quantity])

In situations like this I would normally use a computed column in the query rather than a computed control in a form.  A control in the detail section can then be bound to the column and summed in the way you are currently attempting.

Answer 3

Is [Total Quote] a numeric field in your form's record source? When viewed in data sheet, is it right or left aligned?

Answer 4

What are the control sources of the text boxes that are showing #Error?

Your issue might be that you are attempting to sum a text box control. Your control sources should use only the names of fields in your form's record source.

Thanks Dhookom,

I am using a query, as my record source.

my control sources are in my record source, but it comes up with an error.

I am using =sum([total quote])

Answer 5

What are the control sources of the text boxes that are showing #Error?

Your issue might be that you are attempting to sum a text box control. Your control sources should use only the names of fields in your form's record source.