Its SQL in general that is limiting you. Your where clause filters out any ‘Y’ that will be zero, so they simply don’t exist.

What you want is something like this:

 SELECT
    (SELECT
     Count(t1.x)
     FROM Referrals t1
     WHERE t1.[Today's Date]>#2003/07/29# AND t1.y=t2.y) AS numberOfx,
    t2.y
FROM Referrals AS t2
GROUP BY t2.y
[download]