georgesOne
Technical User
Hi All:
I have this 'simple' (and working) query
and want to change it into vba, but I cannot.
The full query is more complicated, but I am sure this is the culprit.
Any help available?
Thank you so much, georges
I have this 'simple' (and working) query
Code:
SELECT A.ID, A.[201409ST], Switch([A].[201409ST]="New",1,[A].[201409ST]="M0",2,[A].[201409ST]="M1",3,[A].[201409ST]="M2",4,[A].[201409ST]="M3",5,[A].[201409ST]="vHVM",6,[A].[201409ST]="rhVM",7,[A].[201409ST] Like "*XxX*",8, IsNull([A].[201409ST]),9) AS Rating FROM tblWDefinition As A;
The full query is more complicated, but I am sure this is the culprit.
Any help available?
Thank you so much, georges