Complex Query?

[Janet Ciegler]

Is it possible to write a query that searches three text columns in a
single table and uses a parameter to find all instances of a string in
any of those three columns?

 

[PC Datasheet]

Yes! Put the following expression in the criteria of the first field:
Like "*" & [Enter The Search String] & "*"
Put the same expression in the second row of the criteria for the second
field and put the same expression in the third row of the criteria for the
third field .

 

[Janet Ciegler]

Thank you, PCD. That works great! Much simpler than anything I had
devised. Jan

Yes! Put the following expression in the criteria of the first field:
Like "*" & [Enter The Search String] & "*"
Put the same expression in the second row of the criteria for the second
field and put the same expression in the third row of the criteria for the
third field .

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Is it possible to write a query that searches three text columns in a
single table and uses a parameter to find all instances of a string in
any of those three columns?