This one may be a little hard to explain but please bear with me.
For each account, I have a table that contains the fields (for example) tot1, tot2, tot3, etc. I also have a field called grand_tot, which is the sum of all these other fields. To get grand_tot, I put "tot1+tot2tot3...." in my...