Crosstab Report Format 1

[sko]

I have a report based on a crosstab query.
Row = ProductID
Column= ProductType
Value = Count ProductType
The resulting value will always be null or 1.
In the report, I would like to replace 1 with X. Possible?

Type1 Type2 Type3
ProductA X
ProductB X

 

[petersdaniel]

In your report field, make your field be conditional statement. So assuming you had a field called txtType2, the formula would be "=iif([type2]=Null,"X",[type2]) petersdaniel@hotmail.com
"If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein

 

[sko]

I forgot I knew that LOL Thanks