RE: Returning a wildcard or value

Like [Forms]![YourForm]![YourInputField] & "*" or Is Null

"Nathan Hughes" wrote:

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

Relevant Pages

  • 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. ... What I am trying to do is create criteria expressions that will take 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)