Switch statement problems

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top