Forum Discussion
HWK
May 05, 2025Copper Contributor
Access keeps giving syntax error
Hello, I wanted to classify test results in different groups and used this formula for a calculated field in a table: IIf([Testscore1c1]>28,'Plus',IIf([Testscore1c1]>15,'I',IIf([Testscore1c1]>6,'II'...
arnel_gp
May 07, 2025Iron Contributor
you can also use Query and create the Calculated column there:
SELECT
*,
Switch([Testscore1c1]>28,'Plus', [Testscore1c1]>15,'I',[Testscore1c1]>6,'II', [Testscore1c1]>2,5,'III',True,'IV') As Score1,
Switch([Testscore1cR]>28,'Plus', [Testscore1cR]>15,'I',[Testscore1cR]>6,'II', [Testscore1cR]>2,5,'III',True,'IV') As Score2
FROM yourTableName;
HWK
May 07, 2025Copper Contributor
Will that show the results in the table or in a separate query?