troubleshooting Question

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

Avatar of ES-Components
ES-ComponentsFlag for United States of America asked on
Microsoft Access
4 Comments1 Solution53 ViewsLast Modified:
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?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros