Pivot Table Question

  • Thread starter Pivot Table Question
  • Start date
P

Pivot Table Question

Hello,

I have created a pivot table and the data that I am attempting to work with
is a number that is less than one. (i.e. .23 quarts) The tables, querys and
other forms I create show the numbers that are less than one however the
pivot table will not. Can anyone help me fix this?

Thank you in advance for your help!
 
D

dean phillips

The problem is the data type of the field you are trying to see in the pivot
table. In your query rather than just referencing the fieldname use the
function Val to convert the field into a value with decimals. eg [fieldname]
becomes expr1:Val([fieldname]).

Dean
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot Table 1
Percentages in Pivot table 2
Running Percentage Totals for calculated % inside Pivot Table 1
Can't format Pivot Table in Excel 2003 1
Wrap Text in Access Form Pivot table 0
Accumulated Percentage within a Pivot table....CAN ANYONE HELP?!?! 6
PIVOT TABLE VIEW 1

Top