Help with query

[Bartolio]

The table STUDENT has 3 columns ID, Name, Hobby



Soms cells from Hobby are empty, how do I make a query that shows the students that have no hobby?

I thought it was something like this, but i don't know how to refer to the empty cell.

SELECT Name, Hobby
FROM STUDENT
WHERE Hobby = " ";

[RuralGuy]

WHERE Len(Hobby & "") = 0;
...or maybe WHERE IsNull(Hobby) = True;

[Bartolio]

It worked, Thanks!

[RuralGuy]

Excellent! Glad we could help.