F
ftrujill0
Sorry but I'm totally new at this...
I want to create a Search Form based on the items selected from a form that
contains drop down lists. I would have a drop down list that would contain
operators (<,>, AND, OR, etc...) and a drop down list that would contain my
table field names, plus a text box which would allow the user to enter their
condition.
Based on what is entered into the form the items would be passed to the
WHERE condition in the query.
example of what I am thinking....
SELECT X, Y, Z
FROM
TABLE1
WHERE
[PASSED FIELDNAME] [PASSED OPERATOR] [[PASSED FIELDNAME2] etc...
OPTION 2?
Maybe just listing all of the possible table fields and passing the AND/OR
operators
thanks in advance
I want to create a Search Form based on the items selected from a form that
contains drop down lists. I would have a drop down list that would contain
operators (<,>, AND, OR, etc...) and a drop down list that would contain my
table field names, plus a text box which would allow the user to enter their
condition.
Based on what is entered into the form the items would be passed to the
WHERE condition in the query.
example of what I am thinking....
SELECT X, Y, Z
FROM
TABLE1
WHERE
[PASSED FIELDNAME] [PASSED OPERATOR] [[PASSED FIELDNAME2] etc...
OPTION 2?
Maybe just listing all of the possible table fields and passing the AND/OR
operators
thanks in advance