Why doesn't the Form Footer on a form give me a Grand Total?

ES-Components used Ask the Experts™
My Grand Total in the form footer does not work. I get a #Error message.
I used a Query Make Table to create the table I am using is as the Control Source on my form. Table sample is below:

Writer    SumofSales        Expr1    
Tom        100                      100
Harry      250                      250

The form detail section displays the Writer and the SumofSales

In the form footer i used the text box with a name = Text35,
My expression is =SUM([Expr1])

Why doesn't it work?

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Assuming Expr1 is the name of a control, that is the problem.  You need to refer to bound fields from the recordsource rather than control names.

If Expr1 contains a calculation, then simply repeat the calculation
So if Expr1 is:
=fld1 * fld2
=Sum(fld1 * fld2)
Most Valuable Expert 2012
Top Expert 2013

<<I used a Query Make Table to create the table I am using is as the Control Source on my form. >>

If the recordsource of your form is the table created by your MakeTable query, and the table contains a field named "Expr1", then your syntax is ok overall.  However, ensure that the field Expr1 in your table is numeric, not text.  Alternatively, try this:



Look at the Query I used, (file1392748) and the table, (file 1392749)

I tried both of your suggestions, Still not working. It almost feels too simple to do, but I can not figure out why I
get #Error    for an error message.
I currently have the text box in the form footer and get the above error message.

Any other suggestions?

Thank you for any help you can offer!!!
I found my solution. I had originally used the "Form Design" to create my form.
I tried using the "Form Wizard" and used the tabular version.

The Grand Total of the Sales works correctly in the footer section of the form


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial