小吳 VBQA 程式設計討論

Dim mySQL As String
Dim my As String
Dim tt As String
Set rs = New ADODB.Recordset
tt = "192.168.1.101"
mySQL = "select 暱稱 from 聊天明細 where IP like 'tt' "
rs.Open mySQL, cn, adOpenStatic, adLockOptimistic
my = rs.GetString
Text2.Text = my
我想給變數，還後從access裡抓回我要東西，這段where IP like 'tt'的tt是無效，要怎麼寫才能抓回我要的資料，而且抓回後放在變數中