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
I have included a Access 07 demo database to better view the issue.
Thank you,
Heather