S
Steve From New Bern
Ok Here is the problem
I have a table. At the End of the row I have an expression box with a
function that adds the value of every field in that row. On the Last row at
the bottom of the last column I would like to add Grand Total. of that final
column. Using the same formula as I did in the rows only returns a 0.
Example using a 3x3 Table
Cell 1,3 (1st Row & Third Column) is the total for Row One
Cell 2,3 (2nd Row & Third Column) is the total for Row Two
Cell 3,3 (Third Row & Third Column) is the sum of the above two cells.
I am using the following function for the fields.
fx = field1 + field2
fx = field4 + field5
fx = field3 + field6
*****Where Fields 3 & 6 are the expression boxes at the end of the rows*****
I have a table. At the End of the row I have an expression box with a
function that adds the value of every field in that row. On the Last row at
the bottom of the last column I would like to add Grand Total. of that final
column. Using the same formula as I did in the rows only returns a 0.
Example using a 3x3 Table
Cell 1,3 (1st Row & Third Column) is the total for Row One
Cell 2,3 (2nd Row & Third Column) is the total for Row Two
Cell 3,3 (Third Row & Third Column) is the sum of the above two cells.
I am using the following function for the fields.
fx = field1 + field2
fx = field4 + field5
fx = field3 + field6
*****Where Fields 3 & 6 are the expression boxes at the end of the rows*****