Complex Query?

  • Thread starter Thread starter Janet Ciegler
  • Start date Start date
J

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?
 
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 .
 
Thank you, PCD. That works great! Much simpler than anything I had
devised. Jan

PC said:
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?
Click to expand...
Click to expand...
 
Back
Top