I thought Having would do it but this doesn't work.

Michel,

Obviously, Naomi helped you through your query - just one other note....you generally use HAVING in conjunction with a GROUP BY, to filter on an aggregation.

In the absence of any GROUPing, I believe a HAVING will work like a WHERE - though it's much more common to use a WHERE if you're not filtering on an aggregation.