Subform Foot Sum Resulting in #Error

[hrseebeck]

I had a working form but then my client asked for the form to be changed and with those changes my subform is not summing the totals in the footer properly. It is giving me a #Error message. My line total is working fine with the formula =([Size]*[Price])*[Qty] but when I enter =Sum(([Size]*[Price])*[Qty]) it is giving me the error. Any help is greatly appreciated.

I have included a Access 07 demo database to better view the issue.

Thank you,
Heather

 

[Big Pat]

I think you need =Sum([LineTotal]) or whatever your total is called

 

[hrseebeck]

My line total is a calculated field and the sum feature won't work in calculated fields from my understanding.

 

[Ari]

Hi

The problem in this field SIZE, which is also calculated. The output will create the SIZE field in the query, which is the origin of the form.

Follows the modified example.

 

[hrseebeck]

Thank you but how did you add in a non-calculated Size field to have it bring in the value automatically?

 

[Ari]

The Sum() function only works with fields that originate in the table or query. The SIZE field of your form does not originate in the table.

 

[hrseebeck]

Is there a way to get this to work or another way for me to calculate the total?

 

[rodmc]

Stay clear of calculated table fields perhaps

 

[vbaInet]

What form are you talking about? I've just opened frmQuote and it's working as expected.