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

How about

And Date Is Null

Quote:

---

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= " "

Quote:

---

Originally Posted by firoz.raj

You need to put some date inside the Date= " "

---

I think that's just exactly what he doesn't want

Quote:

---

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 .