Searching for specific items

[txdon32]

I have created an invetory database for the organization I work for. One of the fields is called "Location". I want to query the "Location" field to see the equipment located in each area. Simple enough, right? Here's the problem: some of the items are located in multiple places and it is reflected in the database (ie. "Location" for Tape might be populated with "Lower cage, upper cage, storage unit"). Is there a way I can query "Location" to show everything in the "Lower cage" including Tape? I was looking for a "contains" command but couldn't find it. The ultimate goal will be to create a button that does this, but that's a story for a different day. All help is appreciated!

txdon32

 

[___]

See if this simple example is any good for you.

HTH

 

[txdon32]

Big Help

First of all, thank you for your input and I do see what you have done. Here's another question: Creating a search in those formats would still require me to assign differnet ID numbers to similar products located in different places
ie. ID Item Location
1 Tape Lower Cage
2 Tape Upper Cage

The person that input the data (i'm only the designer) put it in this format

ID Item Location
1 Tape Lower Cage, Upper Cage

Do you see the dilemma? It's pretty frustating and I've been looking up stuff all day.

Thanks again - txdon32