checking for nothing?

[MartDawg]

aflag = "YES"

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

Set oLKRS = oLKCon.Execute(sLSQL)
this = oLKRS.Fields("NewField&quot.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.

 

[MartDawg]

this above should be tid

 

[PHV]

Have you tried to play with the IsNull and/or IsEmpty functions ?

Hope This Help
PH.