What does "blank" mean? Is it an empty string, or is the value NULL? How
did it get in there that way?
And what on earth does "doesnt work" mean???
(Reverse address to reply.)
"Sue" <Suehotmail.com> wrote in message
> I have a blank field in the database for Address. How do
> I refer to that? For ex:
> Set hrRS = Server.CreateObject("ADODB.Recordset")
> hrQuery ="SELECT DISTINCT
> Division,Description,Code,Address FROM tblEV3Location
> ORDER BY Division,Description;"
> hrRS.Open hrQuery,adoCon,2,2
> hrDiv = hrRS(0) + "-"+ hrRS(1)
> if hrRS(3)="" Then
> hrCode = hrRS(2)
> hrCode = hrRS(2)+"-"+hrRS(3)
> End If
> This unfortunately doesnt work.