to look for a word in one column?

[Harrold]

Hi

i would like to look a word, Rey, in a column and to display the result. What should i write in the criteria in query?

Thanks

 

[pbaldy]

How about

"Rey"

 

[Harrold]

say in the cell, it has "rey - salary for Jan 2012", "rey - comm for Jan 2012". etc
and i need to extract all the transactions that contains the word 'rey'. so that i can see the entries belong to rey.

Can just put down "rey" will extract for the above transactions also?

Thanks

 

[pbaldy]

No, that would be

Like "*Rey*"

 

[Harrold]

Thanks Paul.

How about two criteria? say, rey and salary?

 

[pbaldy]

The same, separated by "And" or "Or" as appropriate to your needs.