I need help with a form that I would like to show the Total of numbers from Table 6, 7 and 8. I have put in codes for the Subtotals but the final total I can't seem to figure out. Can someone help me with the coding to add subtotal 1, 2 and 3.
I think part of your issue is not having unique names for each field. If you do not then you have to use occurance numbers on the form (that is what I did).
See my attachedrevised sample.
Thanks for a quick response but I noticed also that some of my cells in the table were not numeric so I changed it. The Subtotal is not working. I am getting an error. Your formula was working but it did not include the last total of numbers. It should include tables 6, 7 and 8 totals. Can you look at it again. Thanks again!!
Yes, table 8 is supposed to have the total of all tables from 6, 7 and 8 in each column but maybe it is the way I designed it that makes it confusing.
There are only two tables 6 and 7 that are being added. Table 8 is not being added in with the Total. Table 8 is where Total is listed. If you put numbers in the last table 8, I would like for it to add those plus the two other tables above as one total.