Results 1 to 4 of 4

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

  1. Feb 19th, 2003, 08:47 PM #1
    Job
    Job is offline

    Thread Starter
    Member
    Join Date
    Nov 2001
    Posts
    57

    Post 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!
    Reply With Quote Reply With Quote
  2. Feb 20th, 2003, 03:08 AM #2
    JFK
    JFK is offline
    Lively Member
    Join Date
    Oct 2002
    Posts
    112
    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
    Reply With Quote Reply With Quote
  3. Feb 20th, 2003, 03:50 AM #3
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    VB Code:
    1. Select fldNumber from tblNumbers Where not isnull(fldNumbers) group by count(fldNumbers)
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
  4. Feb 20th, 2003, 08:51 AM #4
    jayakumar
    jayakumar is offline
    Hyperactive Member
    Join Date
    Nov 2002
    Location
    india
    Posts
    418
    hi,

    Select fldNumber from tblNumbers
    where fildNumber is not null
    group by count(fldNumbers)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width