R
RR
Goal:
Display data values in a pivotchart without any decimal places.
Background:
The fields in the query that the pivotchart is based on are set to "Format:
Fixed, Decimal Places: 0" (displays correctly in query). I also made sure the
fields in the pivotchart had this same format in design view.
Problem:
When I add these fields to the pivotchart Access puts the decimal places
back in. I went to the pivottable view and changed the format of the summed
fields to "fixed", but that still leaves me with 2 decimal places I want to
get rid of.
Can someone help?
Thanks.
Display data values in a pivotchart without any decimal places.
Background:
The fields in the query that the pivotchart is based on are set to "Format:
Fixed, Decimal Places: 0" (displays correctly in query). I also made sure the
fields in the pivotchart had this same format in design view.
Problem:
When I add these fields to the pivotchart Access puts the decimal places
back in. I went to the pivottable view and changed the format of the summed
fields to "fixed", but that still leaves me with 2 decimal places I want to
get rid of.
Can someone help?
Thanks.