Criteria Question

  • Thread starter Thread starter benbanyas
  • Start date Start date
B

benbanyas

I want to create a query that searches for words in multiple columns. I
currently have it set up using Like "*" in the criteria for one column and it
works fine, but I want to have the user only have to enter a parameter value
once and have it return results from many columns. Is there a way to do this?
Thanks for any help, I'd really appreciate it!
-Ben Banyas
 
If you enter the exact same parameter under each field then you only get
prompted once.

Criteria: Like "*" & [Find what] & "*"

Now enter that under each field, but on separate lines so that it does
an OR. If you entered the expression on the same criteria line whatever
you are searching for would have to appear in every field.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Back
Top