Results 1 to 5 of 5

Thread: where field is blank (How to do?)

  1. Aug 15th, 2012, 06:48 AM #1
    JamieWarren09
    JamieWarren09 is offline

    Thread Starter
    Fanatic Member
    Join Date
    May 2009
    Posts
    876

    where field is blank (How to do?)

    Hi guys im using the following code to check the database and add the date to a listview


    Set rs = db.OpenRecordset("SELECT * FROM `Leads` WHERE `Agent` = " & "'" & Form1.Text1.Text & "' AND `Calling From` = " & "'" & Form4.Combo1.Text & "' AND `Date` = '' ")



    I am wondering how can i make it only display the records that have a blank Date field?

    At the moment it dont show any date that has a blank date field. How can i make it display them only?

    thanks
    Reply With Quote Reply With Quote
  2. Aug 15th, 2012, 09:28 AM #2
    MarkT
    MarkT is offline
    PowerPoster
    Join Date
    Jun 2001
    Location
    Trafalgar, IN
    Posts
    4,141

    Re: where field is blank (How to do?)

    How about

    And Date Is Null
    Reply With Quote Reply With Quote
  3. Aug 16th, 2012, 07:11 PM #3
    firoz.raj
    firoz.raj is offline
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    Re: where field is blank (How to do?)

    At the moment it dont show any date that has a blank date field. How can i make it display them only?
    You need to put some date inside the Date= " "
    Reply With Quote Reply With Quote
  4. Aug 16th, 2012, 07:42 PM #4
    jmsrickland
    jmsrickland is offline
    PowerPoster
    Join Date
    Jan 2008
    Posts
    11,074

    Re: where field is blank (How to do?)

    Quote Originally Posted by firoz.raj View Post
    You need to put some date inside the Date= " "
    I think that's just exactly what he doesn't want


    Anything I post is an example only and is not intended to be the only solution, the total solution nor the final solution to your request nor do I claim that it is. If you find it useful then it is entirely up to you to make whatever changes necessary you feel are adequate for your purposes.
    Reply With Quote Reply With Quote
  6. Aug 16th, 2012, 10:01 PM #5
    firoz.raj
    firoz.raj is offline
    Frenzied Member
    Join Date
    Jan 2009
    Location
    Watch Window(Shift+f9)
    Posts
    1,879

    Re: where field is blank (How to do?)


    I am wondering how can i make it only display the records that have a blank Date field?
    oh sorry, for my previous post .just you need to check Null value in your sql statment .
    Last edited by firoz.raj; Aug 16th, 2012 at 10:05 PM.
    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