Showing Percents in report

[Guest]

I have the following:

TRANSFORM Avg([numerator]/[denominator]) AS Expr1
SELECT X2.Diagnosis
FROM X1 INNER JOIN X2 ON (X1.Month = X2.Month) AND (X1.Diagnosis =
X2.Diagnosis)
GROUP BY X2.Diagnosis
ORDER BY X2.Month
PIVOT X2.Month In ("07","08","09","10","11","12");

Expr1 is formatted as percent in the crosstab.

I am trying to get the field to show as a percent in the associated report
and have tried formatting the txt boxes and the query but it isn't happening.

When the query field is formatted as percent is displays correctly, how can
I get the same in the report?

Thank you.

 

[tina]

try

Format(Avg([numerator]/[denominator]), "Percent") AS Expr1

you can read up on the Format() function in Access Help for more information
on how the arguments work.

hth