Thanks for your patience!
To answer your questions- The information in the "Products Subform" is all fields directly linked to the tables (no query). The only calculated fields on that subform are the two in the footer which give me the total "WeightOnHand" and...
Thanks, but that still gives me the #Error message.
Let me give you a little more detail. I am tracking inventory. I have several tables, but the two that affect this formula are the "Products" table which has a list of all of the "items", thier "upc codes", and...
I have a calculated field in a form. How do I get a total of that field at the bottom of the page? I tried putting and unbound box in the form's footer with =sum[totalvalue] and I get #Error.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.