Crosstab Query

[kclaw55]

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!

 

[jatfill]

You can try something like the following, either on the query of the report itself to get the results you need (just replace controlname)...

=IIf([controlname]= 1,"X", IIf([controlname]="",0, "Incorrect Value Given"))

This first expression also handles any value in your control that is not either 1 or null (for example 0, 2, etc.), if you don't need that sort of error checking, just change the expression to:

=IIf([controlname]= 1,"X", 0)

Good Luck...