Hello,
How do you keep null out of a group?
IE - Select fldNumber from tblNumbers group by count(fldNumbers)
the problem is that there are some null values in fldNumbers, and I can't have null returned as a value.
Please help!
Printable View
Hello,
How do you keep null out of a group?
IE - Select fldNumber from tblNumbers group by count(fldNumbers)
the problem is that there are some null values in fldNumbers, and I can't have null returned as a value.
Please help!
Can you set the default value for the field to 0 then filter for values > 0 ?
Alternatively search for values in that field that Is Not Null
JFK
VB Code:
Select fldNumber from tblNumbers Where not isnull(fldNumbers) group by count(fldNumbers)
hi,
Select fldNumber from tblNumbers
where fildNumber is not null
group by count(fldNumbers)