hey thanks! can't believe it was as simple as 0 -> NULL. doh. count() works as expected now.
On Jun 20, 2004, at 11:17 AM, Markus Bertheau wrote:
Ð ÐÑÐ, 20.06.2004, Ð 17:44, kumar mcmillan ÐÐÑÐÑ:
hi.
I am using a pseudo "pivot table" SQL query to generate a report butI
am totally stumped on wh
Ð ÐÑÐ, 20.06.2004, Ð 17:44, kumar mcmillan ÐÐÑÐÑ:
> hi.
> I am using a pseudo "pivot table" SQL query to generate a report butI
> am totally stumped on why the COUNT() function isn't getting me
> theexpected results and was wondering if anyone has some ideas...
>
> it is for a statistical report s
hi.
I am using a pseudo "pivot table" SQL query to generate a report but I am totally stumped on why the COUNT() function isn't getting me the expected results and was wondering if anyone has some ideas...
it is for a statistical report showing which lead source a member followed when creating a p