Good Morning,
I have a Union database in which I have grouped my Local Officers by their Local number, then I want to have them sorted by position. I have written an expression, but I'm getting an error (Syntax error (comma) in query expression) but I can't find the error!
I want them to be listed 1. president, 2 acting president...etc...(as seen below)
The Query is for the "Upload" table, and the information is to be sorted by "Union Position Standard Name".
Can anybody see the error of my ways?
"Expr1: IIf([Union Position Standard Name]="President",1,IIf([Union Position Standard Name]="Acting President",2,IIf([Union Position Standard Name]="Vice-President",3,IIf([Union Position Standard Name]="1st Vice-President",4,IIf([Union Position Standard Name]="2nd Vice-President",5,IIf([Union Position Standard Name]="3rd Vice-President",6,IIf([Union Position Standard Name]="Secretary",7,IIf([Union Position Standard Name]="Treasurer",8,IIf([Union Position Standard Name]="Secretary / Treasurer",9,IIf([Union Position Standard Name]="Chief Steward",10,IIf([Union Position Standard Name]="Shop Steward",11,IIf([Union Position Standard Name]="Misc Contact",12,IIf([Union Position Standard Name]="Health & Safety",13,IIf([Union Position Standard Name]="Communication Officer",14))))))))))))))"
Jennifer
Bookmarks