G
Guest
First and foremost I do not have the experience to code in VB, so if possible
please limit your responses to using the GUI.
I have a query that I am trying to run that uses form data as selection
criteria. i.e. [Forms]![Data]![ClientID], etc. I am trying to set the
Operator for this criteria as a variable so that I could make it =/<>/like
etc. This does not appear to be working as the results always come back
blank. Is there a way to create an operator variable? I searched the web
but found no information, likewise with this forum.
My end result would be to have two variables, pulled from two data fields
entered in a form, in the same selection criteria box. (One would be the
operator and the other would be the list of values.)
[Forms]![Data]![ClientOperator][Forms]![Data]![ClientID]
Any assistance you could provide would be appreciated.
please limit your responses to using the GUI.
I have a query that I am trying to run that uses form data as selection
criteria. i.e. [Forms]![Data]![ClientID], etc. I am trying to set the
Operator for this criteria as a variable so that I could make it =/<>/like
etc. This does not appear to be working as the results always come back
blank. Is there a way to create an operator variable? I searched the web
but found no information, likewise with this forum.
My end result would be to have two variables, pulled from two data fields
entered in a form, in the same selection criteria box. (One would be the
operator and the other would be the list of values.)
[Forms]![Data]![ClientOperator][Forms]![Data]![ClientID]
Any assistance you could provide would be appreciated.