J
John
I have the following result from a query.
NameID Round Game Pick
Weston 1 1 H
Weston 1 2 H
Weston 1 3 A
Weston 1 4 H
Smith 1 1 D
Smith 1 3 A
Smith 1 4 H
Able 1 2 D
Able 1 3 A
Able 1 4 H
Thoms 1 1 D
Thoms 1 2 H
Thoms 1 3 A
Norling 1 1 D
Norling 1 2 H
Norling 1 3 A
I need to be able to convert the pick field to numbers.
Say IIf(D),4,2 but I have no idea as to were I should
Place the expression, and then sum the result per person.
Any pointers would be appreciated.
John
NameID Round Game Pick
Weston 1 1 H
Weston 1 2 H
Weston 1 3 A
Weston 1 4 H
Smith 1 1 D
Smith 1 3 A
Smith 1 4 H
Able 1 2 D
Able 1 3 A
Able 1 4 H
Thoms 1 1 D
Thoms 1 2 H
Thoms 1 3 A
Norling 1 1 D
Norling 1 2 H
Norling 1 3 A
I need to be able to convert the pick field to numbers.
Say IIf(D),4,2 but I have no idea as to were I should
Place the expression, and then sum the result per person.
Any pointers would be appreciated.
John