G
Guest
I have an access 2003 query that looks at our general ledger data and
crosstabs it into rows by account number, columns by month. Everything ties
out perfectly in the query itself. When I build a pivot table view, all the
cents are dropped and dollars only are displayed and calculated, causing
rounding errors and out of balance conditions. Is there a setting I am
missing? Changing the format doesn't change anything. Again, the underlying
query returns perfectly.
I am posting this in "Queries" as there is no pivot category. Please advise
if another forum is more appropriate.
Thanks in advance!
crosstabs it into rows by account number, columns by month. Everything ties
out perfectly in the query itself. When I build a pivot table view, all the
cents are dropped and dollars only are displayed and calculated, causing
rounding errors and out of balance conditions. Is there a setting I am
missing? Changing the format doesn't change anything. Again, the underlying
query returns perfectly.
I am posting this in "Queries" as there is no pivot category. Please advise
if another forum is more appropriate.
Thanks in advance!