I have a form that has a pivot chart. The number that is displayed is always an even number when I know that there must be some numbers after the decimal place. The problem is it just chops off the decimal points. It doesn't round up or down, it just truncates the numbers.
The problem is I need to see exact numbers in my pivot chart! The curious thing is that if I export the pivot chart to a data access page, it doesn't round the numbers and gives me the exact number out to the decimal places. I need to be able to have the exact number in my form without rounding, it makes reconciling a lot easier!
How can I get a pivot chart in a form to stop rounding (truncating)?