Return all items including letters "bird"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to create a query that would return me all Items in that table
that include "bird" somewhere, including Bird House, Bluebird, etc... I tried
wildcards with hno success.

Thank you for your time.
 
Access said:
Hi,

I'm trying to create a query that would return me all Items in that table
that include "bird" somewhere, including Bird House, Bluebird, etc... I tried
wildcards with hno success.

Thank you for your time.
Click to expand...

Hello fellow Access Student,

Have you looked at the LIKE operator?
 
I looked into that as well.
Fortunately I found a good way with wildcards.
There needed to be three different criterias,

bird*
*bird
and *bird*

That should cover all results.
Thanks again for your time.
 
Actually, just "*bird*" would be needed since that would include both the
other options

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top