Syntax in MS ACCESS SWITCH() when coulumn is NULL
Posted on 2010-08-24
I'm getting an error on the column which has a Null value using SWITCH(). Tried to convert it but it seems i've used the wrong syntax. Please help...
Onmy statement below, the error i'm getting is for the last column output (T_Assessment_Score)
nz(a.Assessment_Score,"IS NULL") as ORIG_rawScore
cstr(a.Assessment_Score) > 36, "88888",
cstr(a.Assessment_Score) < 0, "88888",
cstr(nz(a.Assessment_Score,"IS NULL")) = 'IS NULL', "99999",
) as T_Assessment_Score
FROM T_ASSESMENT_MONITORING AS a, T100_MON_CAT_DOC AS c
WHERE a.Assessment_period='2010 Term 3'
And a.Form='4/5 M'