"john" <jo**@test.comwrote in
news:xt********************@casema.nl:
SELECT DISTINCT Ap2.test1, Count(Ap2.test1) AS AantalVantest1
FROM Ap2
GROUP BY Ap2.test1;
gives me a record count per unique value of test1 field. How
do I include the count of all the records without a value? The
table resulting from the query just shows an empty value with
0 as the count which is not correct.
thanks,
john
Your problem is that instances of ap2.test1 are null, which access
properly refuses to count. Change the count() to count something
which is not null. Use count("X") AS AantalVantest1 instead.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from
http://www.teranews.com