How do I?

[Rey]

My problem is the following:
I have a table thak contains equipment reservation information of peple who need to use these euqipment, in the equipment field I want to have different kinds of equipment such as Overheads, Laptops, LCDs, and so on, and I also want to have a query where I can specify one item and want to retrive all records that contain this item. For example:
in the equipment field I have LCD, OH, Laptop for one record, and when I do my query where it askes me to enter the equipment I want to query, I only wanto to enter OH, and I want this query to show me all the records that contain OH even if it show me records that contain other equipment that OH.
I only have one table to run this query from.
Maybe this makes sense, maybe not; if it doesn't, I can try to clarify abit more.

Thanks

 

[mark curtis]

In the criteria section of the query, under the field that contains the equipment place the following:

=[Enter Equipment Name]


Run the query and you will be prompted to enter the text you want to search on.

 

[Rey]

I tried =[enter equipment name], and I tried [enter equipment name] with out the equal sign, which if I am not mistaken is the same as the one with the = sign. It does give me some of the resulsts I want, but the records that contain other quipment items do not show. for instance, I enter query for OH, and I have records that contain OH, LCD, VHS, TV. When I run the query for OH, this record won't appear in my results.

Thanks Mark

 

[mark curtis]

zip up the db or attach a screen shot of the queryand i'll take a look

 

[wcrc]

one way to do it

Not to horn in, but if I read the first post right you have "OH, LCD, laptop" All in one field. You should probably not have your data all bunched up like that, but I have a fix if this is the case.


When the query prompts you for a parameter for equipment type, use the like parameter and put wildcards at each end.

in the query criteria: like [Equipment Type]

in the dialog box: *LCD*


HTH

 

[mark curtis]

You could even create a form and use a combo box, selecting Distinct values and refer to the combo selection in the query criteria.

 

[Rey]

I tried having different tables, but I still had problems. I also tried the wild cards with this new table, and still did not get the results I was looking for.

Here is an exaple of my dbs if you like to take a look at it.

 

[Jon K]

Like "*" & [enter Equipment] & "*"

should return those records that contain OH

 

[Rey]

THANK YOU!!!!!!! everyone. John, the statement you sent does work.
Again thanks everyone who helped.

Rey

--It does help to ask--