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

Similar Threads

Problem with If statement 5
Problem with Switch function 2
I think the problem is in .SetSourceData ?? 2
A Comparison of Office 2007 with OpenOffice.org 0
Else Without If 8
Addin button not showing up -- problem with ActiveExplorer? 4
2 Dim Array Sort, on any columns, ascend or descend. Guidance des 0
Print Search Listbox Results in Report Filter Preview ... HELP!!! 0

Top