Returning a wildcard or value

From: "Nathan Hughes" <Nathan Hughes@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 9 Aug 2005 11:16:03 -0700

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.
.

Follow-Ups:
- RE: Returning a wildcard or value
  - From: KARL DEWEY

Prev by Date: Re: How do I see Null Values in a field that is text?
Next by Date: Re: parameter query not prompting for parameter
Previous by thread: Query works alone, but not with form
Next by thread: RE: Returning a wildcard or value
Index(es):
- Date
- Thread

Relevant Pages

RE: Returning a wildcard or value
... > I have created a form from which to create tailored reports via several ... There is an underlying query to form these reports. ... > value entered and use that as a criteria and if no value is entered in the ... > If the control on the form has not had data entered, ...
(microsoft.public.access.queries)
RE: Returning a wildcard or value
... >> I have created a form from which to create tailored reports via several ... There is an underlying query to form these reports. ... >> value entered and use that as a criteria and if no value is entered in the ... >> If the control on the form has not had data entered, ...
(microsoft.public.access.queries)
Re: Conditional formatting changes field enabled property?
... The CF routine can only handle 3 criteria. ... Your conditional formatting VB code almost ... "Stephen Lebans" wrote: ... applied, on a Control by Control basis, based on the criteria YOU set. ...
(microsoft.public.access.forms)
Re: Select query populating list box
... Every time you add one more criteria to the where clause, ... However if you look at my original code the text control needs to search ... FROM tbldocument LEFT JOIN tblInstitution1 ON tbldocument.txtRefNbr = ...
(microsoft.public.access.queries)
Re: Select query populating list box
... I should have more coffee. ... Every time you add one more criteria to the where clause, ... However if you look at my original code the text control needs to ... FROM tbldocument LEFT JOIN tblInstitution1 ON tbldocument.txtRefNbr ...
(microsoft.public.access.queries)