Prev: combobox uses query - filter set by checkbox ?
Next: Access and Outlook Reminders
From: Glenda on 20 May 2010 15:17
In a report / Query, I'd like for the database to recognize all inputs that
are similar to the field. In the Query I am putting [Title?]. What do I
need to add so the responses will e.g. include all titles that include the
word "happy"?


--
Glenda
From: John W. Vinson on 20 May 2010 15:39
On Thu, 20 May 2010 12:17:01 -0700, Glenda <Glenda(a)discussions.microsoft.com>
wrote:

>In a report / Query, I'd like for the database to recognize all inputs that
>are similar to the field. In the Query I am putting [Title?]. What do I
>need to add so the responses will e.g. include all titles that include the
>word "happy"?

Use a criterion of

LIKE "*" & [Title?] & "*"

--

John W. Vinson [MVP]
From: Daryl S on 20 May 2010 15:48
Glenda -

If [Title?] is the parameter, and the user would enter "happy", then in your
critera, use this:
Like "*" & [Title?] & "*"

--
Daryl S


"Glenda" wrote:

> In a report / Query, I'd like for the database to recognize all inputs that
> are similar to the field. In the Query I am putting [Title?]. What do I
> need to add so the responses will e.g. include all titles that include the
> word "happy"?
>
>
> --
> Glenda
From: Glenda on 20 May 2010 17:11
wow, in a million years I wouldn't have thought of this... thank you both
--
Glenda


"John W. Vinson" wrote:

> On Thu, 20 May 2010 12:17:01 -0700, Glenda <Glenda(a)discussions.microsoft.com>
> wrote:
>
> >In a report / Query, I'd like for the database to recognize all inputs that
> >are similar to the field. In the Query I am putting [Title?]. What do I
> >need to add so the responses will e.g. include all titles that include the
> >word "happy"?
>
> Use a criterion of
>
> LIKE "*" & [Title?] & "*"
>
> --
>
> John W. Vinson [MVP]
> .
>
From: Glenda on 20 May 2010 17:12
in a million years I wouldn't have thought of this, thank you
--
Glenda


"Daryl S" wrote:

> Glenda -
>
> If [Title?] is the parameter, and the user would enter "happy", then in your
> critera, use this:
> Like "*" & [Title?] & "*"
>
> --
> Daryl S
>
>
> "Glenda" wrote:
>
> > In a report / Query, I'd like for the database to recognize all inputs that
> > are similar to the field. In the Query I am putting [Title?]. What do I
> > need to add so the responses will e.g. include all titles that include the
> > word "happy"?
> >
> >
> > --
> > Glenda
 | 
Pages: 1
Prev: combobox uses query - filter set by checkbox ?
Next: Access and Outlook Reminders