Hello All,
I would like to get ideas from the experts on how to design a form that allows the user to type values similar as if he/she is typing the values in the criteria section of a query. I want my form to translate the input into SQL statment just like MS Access automatically translets the input of users in queries into SQL statements.
I want the user to type in the values using combo box or list box and be able to type in more than 1 value per field. For instance:
Criteraia Field1 Field2
<>A And <>B = STD
=A Or =C <> STD AND <> HD
I would like to translate these values into:
WHERE ((Field1 <> A and Field1 <> B) AND (Field2=STD)) OR ((Field1 =A or Field1 =c ) and (Field2<>STD and Field2<>HD)
and be able to store the where code instead of the values.
Thanks,
LM
I would like to get ideas from the experts on how to design a form that allows the user to type values similar as if he/she is typing the values in the criteria section of a query. I want my form to translate the input into SQL statment just like MS Access automatically translets the input of users in queries into SQL statements.
I want the user to type in the values using combo box or list box and be able to type in more than 1 value per field. For instance:
Criteraia Field1 Field2
<>A And <>B = STD
=A Or =C <> STD AND <> HD
I would like to translate these values into:
WHERE ((Field1 <> A and Field1 <> B) AND (Field2=STD)) OR ((Field1 =A or Field1 =c ) and (Field2<>STD and Field2<>HD)
and be able to store the where code instead of the values.
Thanks,
LM