I have a MS access database linked to a SQL Server table that contains a currency field.
The field shows decimal places when I view from a table and query.
The field does not show decimal places when I pop this into a Pivot Form.

How do I get decimal places to show? Select currency as the format but .00 shows but no cents (i.e. 10.99 goes to 10.00 in the pivot table)