Forum Discussion

HWK's avatar
HWK
Copper Contributor
May 05, 2025

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'...
access
office 365
Tom_van_Stiphout's avatar
Tom_van_Stiphout
Iron Contributor
May 05, 2025

Can we step back and first discuss your table design? I have a suspicion this can be done in a better way. Show us a screenshot of your table in design view.

  • HWK's avatar
    HWK
    Copper Contributor
    May 06, 2025

    I'm quite new to databases and Access. I did read something online about having a separate table with minimum and maximum values. But I couldn't follow and thought this would be an easier way to do things for now. This is my table in design view:

    So, what I want to do with the database is the following: I have students from three villages who take different tests. It is a bit like the DrieMinutenToets and CITO tests. So I would like to classify their scores into quartile groups and outliers as well. I am expecting to get more data and therefore have to change the quartile minimums and maximums as well.

Resources