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?