G
Guest
I have created a form from which to create tailored reports via several
unbound input fields. There is an underlying query to form these reports.
What I am trying to do is create criteria expressions that will take the
value entered and use that as a criteria and if no value is entered in the
form to not have criteria on that value.
I have attempted to use IIf statements unsucessfully.
Basically what I want it to do is:
If the control on the form has had data entered, use that as criteria for
the query
If the control on the form has not had data entered, then act like there is
no criteria.
Many thanks in advance for any assistance.
unbound input fields. There is an underlying query to form these reports.
What I am trying to do is create criteria expressions that will take the
value entered and use that as a criteria and if no value is entered in the
form to not have criteria on that value.
I have attempted to use IIf statements unsucessfully.
Basically what I want it to do is:
If the control on the form has had data entered, use that as criteria for
the query
If the control on the form has not had data entered, then act like there is
no criteria.
Many thanks in advance for any assistance.