Complex Query?

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?
 
P

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 .
 
J

Janet Ciegler

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
[email protected]
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...
 
Top