J
JasonJ
In my Access form pivot table, the grand total row repeats all of my data
rather than totaling it. So, if a column has $0, $500, and $0, the Grand
Total column lists out $0, $500, and $0 rather than a single line with a
total of $500. This happens in every field across the table so in some places
it makes a list of 10 or so numbers. Why is it re-listing data rather than
totaling it? All it seems to be doing is filtering out empty cells.
rather than totaling it. So, if a column has $0, $500, and $0, the Grand
Total column lists out $0, $500, and $0 rather than a single line with a
total of $500. This happens in every field across the table so in some places
it makes a list of 10 or so numbers. Why is it re-listing data rather than
totaling it? All it seems to be doing is filtering out empty cells.