How can I write a multiple conditional SQL expression? The problem is that the user types in the 2 expressions to cross reference.
Printable View
How can I write a multiple conditional SQL expression? The problem is that the user types in the 2 expressions to cross reference.
you could use OR in place of ANDCode:Dim first
Dim second
first = text1
second = text2
sSQL = "SELECT * FROM [table] WHERE [field] = " & first & _
" AND [field] = " & second;"
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.