Specifing Query Criteria using form

[John M]

Hi All,

I have two fields on a form that I want to use in a query:

First Field : used to specify operator (i.e. >, >=, <, =<, =)
Second Field : used to specify number

I want user to enter values in form so that I can run query using these combination of values, i.e. >6 or >=6. How can I do that? What do I enter in criteria field in query builder? Otherwise is there another way to do it?

Any help is appreciated. Thx

 

[jfgambit]

Perhaps this will be of help.

Use SQL to re-write the query parameters with the On Click Event of a command button.

HTH