Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

checking for nothing?

Status
Not open for further replies.

MartDawg

Programmer
Jan 14, 2004
33
US
aflag = "YES"

sLSQL = "Select Min(afield) as Newfield From atable where anotherfield is null"

Set oLKRS = oLKCon.Execute(sLSQL)
this = oLKRS.Fields("NewField").Value
Set oLKRS = nothing

if tid = "" then
aflag = "NO"
end if

If my query brings nothing back....tid is blank.

How can I check for something that is blank. the "" doesn't seem to catch it as aflag never gets to NO

Thanks to anybody who replies.
 
Have you tried to play with the IsNull and/or IsEmpty functions ?

Hope This Help
PH.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top