SQL queries

How can I write a multiple conditional SQL expression? The problem is that the user types in the 2 expressions to cross reference.

Code:

---

Dim first
Dim second

first = text1
second = text2

sSQL = "SELECT * FROM [table] WHERE [field] = " & first & _
      " AND [field] = " & second;"

---

you could use OR in place of AND

Is it possible to use a variable in place of the field name?

dim first as string
dim second as string

these are both variables that
will get the information from 2 textboxes..

this was an assumption on my part of how
you would get the data initially.

then the text in the textbox is assigned to
the variables first and second.