Simple select from table

[jamesmills]

Hey people

I have the SQL code i need to select a falue from a table but i am unsure how to run it

for example
SELECT serverIP FROM tblServerList WHERE serverType = currentServerType AND serverName = currentServerNumber

i need the string serverIP to have the value that this will get from the table
i understand it to have somthign to do with recordset?

thanks in advance

 

[zrzr]

If you only need one value on one table, you can use DLOOKUP function :

dim serverIP as string
serverIP=Dlookup("serverIP","tblServerList", _
"serverType = " & currentServer & " and serverName=" currentServerNumber)

That's all