Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Queries using Access

Status
Not open for further replies.

adamtate

Technical User
Dec 18, 2002
23
GB
I have a field called description in a database, and I want to be able to search for a section of the description.

My criteria at the moment is [Enter Description] so that I get the input box.

If i was searchnig for "Tool Kit" I want to be able to enter "Tool" and it would return the record.

Not used access in a while, can you tell!?

Please help!?

Thanks and regards,

Adam Tate
 
Hi

Just type 'tool*'

or

use the LIKE operator in your where clause of the query
 
Just trying it out, it looks like you need to use LIKE and enter Tool*

 
Hi adamtate,

To find "Tool Kit" on entering "Tool" (as you asked), set your criteria to ..

Like [Enter Start of Description] & "*"

If you also wanted to find "My Tool Kit", for example, then you would add an astersik at the front ..

Like "*" & [Enter part of Description] & "*"

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.
 
Cheers guys. Really appreciate it. It's just the LIKE bit I couldn't figure out :D


Thanks again

Adam Tate
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top