Forum Discussion
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'...
Hi,
It is strange that you would have to use ' instead of ". That shouldn't matter. The comma is even more strange. AFAIK the default for Dutch is semicolon as list separator. If you haven't changed that in the Windows regional settings, then you will have to use the semicolon as separator in every expression in Access including calculated fields:
IIf([Testscore1c1]>28;'Plus'; etc.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK
It says commas as list separators. I started with " " for true and untrue, but it didn't work. Then I changed the " to ' and it worked, for some reason. But when I did exactly the same but for Testscore1cR it doesn't work.
