Link to home
Start Free TrialLog in
Avatar of ES-Components
ES-ComponentsFlag for United States of America

asked on

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

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?

Thanks...
Rick
Avatar of PatHartman
PatHartman
Flag of United States of America image

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
Then
=Sum(fld1 * fld2)
<<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:

=SUM(Val(NZ[Expr1],0))
Avatar of ES-Components

ASKER

User generated imageUser generated image
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!!!
ASKER CERTIFIED SOLUTION
Avatar of ES-Components
ES-Components
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial