J
Junior
This was working in a series of iif statments until i added one more -now
trying to get it to work in a switch statment
This is in a txtbox on a report - RefGrp =1 prints correctly
i want to print RefGrp if none of these is true. However, now the txtbox
shows Error if none of these is true.
what am i doing wrong?
=Switch([RefGrp]=1,"Transfer Eligible",[RefGrp]="1Q","Education
missing",[refGrp]="2Q","experience missing",[refGrp]="3Q","Specialty
experience missing",[refGrp]="5Q","Location missing",[refGrp]="6Q","Position
missing",[refGrp]="7Q","Undefined data",[refGrp],True)
trying to get it to work in a switch statment
This is in a txtbox on a report - RefGrp =1 prints correctly
i want to print RefGrp if none of these is true. However, now the txtbox
shows Error if none of these is true.
what am i doing wrong?
=Switch([RefGrp]=1,"Transfer Eligible",[RefGrp]="1Q","Education
missing",[refGrp]="2Q","experience missing",[refGrp]="3Q","Specialty
experience missing",[refGrp]="5Q","Location missing",[refGrp]="6Q","Position
missing",[refGrp]="7Q","Undefined data",[refGrp],True)