J
Jeff C
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.
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.