I don't want null in my group...

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)