different value formats in crosstab

[Guest]

I have built a union query of 8 different calculations and then transformed
this into a crosstab query with the month as the column, a label as the row
and the value for the calculation. Some of the values need to show in the
report as a percentage. between formatting the value iin the crosstab and
formating the textbox in the report is there a way to show those that need to
be a percentage and those values that are integers as such? Using an iif
statement I have gotten the percentage values to show in the query as
"##.####". Anyone have an idea?

Thank you very much.

 

[Allen Browne]

Leave the numeric values alone in the query.

Format the text boxes in the report.