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 06, 2025Iron Contributor
what is your Locale list separator character? isn't it comma (;)? then use it instead of comma (,) in your Calculated field Expression.