Queries using Access

[adamtate]

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

 

[Nowell]

Hi

Just type 'tool*'

or

use the LIKE operator in your where clause of the query

 

[BNPMike]

Just trying it out, it looks like you need to use LIKE and enter Tool*

 

[TonyJollans]

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.

 

[adamtate]

Cheers guys. Really appreciate it. It's just the LIKE bit I couldn't figure out


Thanks again

Adam Tate