Wildcard Search On Memo

[prodtest]

Hi,
I have an electronics components database which contains a text field for each component entry, in this text field is the discription and value of the component.
see below:

partno descprition
-----------------------
11056801 res 1k 5% 0603
11056902 res 10k 2% 0805
11057001 cap 100n 0603
etc

I need to be able to create a query that searches all entries for a particular thing i.e. all entries that contain "100n" in the desciption or "0805" in the description.
Is it possible to have a query where you enter say *100n* and it returns all entries 100n in it ???

Thanks in advance

Ben

 

[prodtest]

Sorry just remember I forgot to change title of thread to
"Wildcard Search On Text Field"

Ben

 

[Remou]

Yes it is. Use Like:
... WHERE description LIKE "*100n*"

This would, of course, just be
LIKE "*100n*"
On a criteria line.

 

[prodtest]

Thanks Remou

So how would I adapt this to work with a text box on a form, so the engineer would just enter in 100n and click a button ?

Cheers

Ben

 

[Remou]

You will need to add a few lines to that, I'm afraid. What do you see happening? That the current form is filtered? That a new form pops up? That a query showing the results is opened?

 

[prodtest]

Sorry Remou
Having a blonde moment !!! Sorted it !! Works perfectly !!
Cheers
Ben