Cross Tab Query; not showing %

[Gabriel2012]

Hello, my predicament is as follows; I am pulling data into a cross tab query, the field selected to show under each column is stored as a % in the original query, however after the cross tab query runs it stores it as a number with multiple decimal places. Below is a simplified example, when I change the format of the "accuracy" percentage in the cross table query to "percent", it has no effect.



Original query:

Supervisor name, Period, Accuracy
SMITH 1 95%
SMITH 2 95%
BOB 1 95%
BOB 2 95%

Cross tab query results:

Supervisor Name, Period 1, Period 2
SMITH 95.000 95.0000000
BOB 95.000 95.000000


Any help is appreciated!

[June7]

You mean the data is stored as a number and formatted for percent display?

I tried to replicate the issue. I created a number field and set it for percent format. The data entered as 95 or .95 didn't matter. The table shows 95%, 85%, etc. The crosstab shows 0.95, 0.85, etc.

Appears formatting doesn't pass through to crosstab and I can't get the result you see.

Want to provide db for analysis? Follow instructions at bottom of my post.