Typing part of word in Query

[jamespeters01]

Hi all,

I used to remember how to do this but for some reason I havn't a clue now.

I know its possible to type, for instance the 1st three letters of the field you have set the criteria on, and it pulls all the records that include those 3 letters in any part of the word / phrase.

for instance, I'm looking to find all records that relate to "Accounts Payable, sales, orders" and I would like to just be able to type "Accounts"

Can someone please refresh my mind.


Thanks

 

[lespaul]

use the LIKE operator:

this will find all instance where the beginning of the word is ABC
WHERE SomeField LIKE 'ABC*'

this will find all instance where the end of the word is ABC
WHERE SomeField LIKE '*ABC'

this will find all instance where ABC is found anywhere in the word
WHERE SomeField LIKE '*ABC*'


HTH




Leslie

 

[jamespeters01]

Thanks leslie,

But I would like to use a similar function to [Type Source name ?] in the criteria and the user only has to enter part of the word and all fields with those letters are pulled.




Thanks

 

[lespaul]

then I believe you would put:

WHERE SomeField LIKE [Type Source Name:] & "*"

Leslie