K
kclaw55
Guest
I have created a report based on a crosstab query. The crosstab query shows me who has attend specific classes and indicates a "1" if they have attended. If they have not, the cell is blank.
I wish to replace the "1" with a X in my report and the blank with a 0.
Is this possible? I am at loss..and have tried to use the NZ function in the crosstab query itself..but I am uncertain where to place it to make it work for my report.
Thank you!
I wish to replace the "1" with a X in my report and the blank with a 0.
Is this possible? I am at loss..and have tried to use the NZ function in the crosstab query itself..but I am uncertain where to place it to make it work for my report.
Thank you!