This problem started fter an upgrade from Access 97 to Access 2000 off of Windows XP.
I have a query that when run standalone returns a specific value ondata of $49.50. When this data is inputed into a Pivot Table form its shows as $49.00. I have adjusted all values to be currency. I even created a "quick" straight form and the value appears as $49.50. Is there a quirk with Pivot Tables? Anyone more familiar with Pivot Tables than I that may have suggestions I would be very appreciative.
I have a query that when run standalone returns a specific value ondata of $49.50. When this data is inputed into a Pivot Table form its shows as $49.00. I have adjusted all values to be currency. I even created a "quick" straight form and the value appears as $49.50. Is there a quirk with Pivot Tables? Anyone more familiar with Pivot Tables than I that may have suggestions I would be very appreciative.