PivotTable & Percent

[Seth]

Trying to create a pivot table with a field defined as a
percent with two decimal places. Looks good in table and
query; however, when creating the pivotable the field
format is lost and all valid percentages result in zeros
(except for the 100% = 1). After redefining the field as
a percentage in the pivot table, the data remains as
zeros. Can anyone help me retain the data as a percentage
from the table and query?

Thanks,

Seth