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.
sLSQL = "Select Min(afield) as Newfield From atable where anotherfield is null"
Set oLKRS = oLKCon.Execute(sLSQL)
this = oLKRS.Fields("NewField"
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.