I am attempting to make a table of account numbers that have and have not 
submitted info into a database.

I need to check to see if a field is null or has no text.

here is my SQL string:

SQLresp = "Select Milestones.* From Milestones Where Milestones.TIGNumber 
= '"&RSstate("TIGNumber")&"' AND (Milestones.Report is Null OR 
Milestones.Report = '');"

The TIGNumber is working just fine and I can get it to show when a user 
has entered data by removing the end of the SQL string:

SQLresp = "Select Milestones.* From Milestones Where Milestones.TIGNumber 
= '"&RSstate("TIGNumber")&"' AND Milestones.Report is Null;" 

This works fine, but in the case the the user wants to delete his info by 
submitting blank fields I have to use this:

SQLresp = "Select Milestones.* From Milestones Where Milestones.TIGNumber 
= '"&RSstate("TIGNumber")&"' AND Milestones.Report = '';"

which will no longer list an empty field but at the same time will not 
recognize a full one.

What i really need to both of this tests but I can not get it to do this.

Anyone have an idea why?

I cant seem to get it.

Thanks