Case Is "Blank"

[n107jkx]

I have a number of different cases in a module, which each bring up different values for a field in a query. However, i need to bring up a special value when the "case field" is blank.

I am sure there will be an easy answer, but I have tried Case Is = "" and this does not work.

Can anybody help?

 

[n107jkx]

I have my Abs feature working, but is there any way i can total up the number of absences - either in total or for each student. I have tried queries and module functions, but i cant seem toget it right. I keep getting the same message:

"You tried to execute a query that does not include the specified expression 'Student_Number' as part of an aggregate function"

Does anybody know what this means? I can't even find it on help!