Hello Experts:
I need some assistance with modifying a crosstab query IOT to include "0" values where cells are empty.
Pls see below two attached pictures illustrating the a) crosstab and b) output of the crosstab.
Values in field [T102_N1S_Staffmember].[All_MOC_TrainingStatus] can take on two values: "Completed" or "Not Completed".
These two values are converted as my column headings... now, while the crosstab output itself is correct, I'd like to show a zero, e.g., at intersection "Org 1" & "Completed". The 2nd JPG illustrates it in detail.
I tried including the NZ function for StaffMemberIDpk but the output doesn't not change.
Code:
Expr1: Nz([StaffMemberIDpk],'Not Found')
Expr1: Nz([StaffMemberIDpk],Null)
My question: How can I force the output of zero where a value is blank?
Thank you,
EEH