Conditional Formatting in a CrossTab Query

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

Is it possible to change formatting based on the specific value in a
crosstab query?
Basically I have some queries where the output is a percentage. I have it
displaying 0 decimal places.
BUT, if the value is not 0, but < .5 that rounds to 0. I don't want it to do
that.
I want it to either display a character (i.e.. "#" ) or under those
circumstances change to maybe 2 decimal places.
I tried an IIF statement but if gave me one of those "too complicated
errors".
The IIF I used was IIF([parameter]<.5,"#",[parameter]). I've used this kind
of stuff before but I never tried it in a crosstab query before.
 
I do all formatting in a report control. I find it is a waste of time
attempting to format any field/column in a query.
 
Back
Top