Difficult "Select Query" in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set up a select query that prompts the user for a string and then
searches TWO or more fields (columns) for ocurrences of the input string? I
know how to do a query if I only need to search for the input string in ONE
field (column) of the database. Any thoughts?
 
SELECT * FROM yourTable WHERE fieldToSeach = [Search String] OR
otherFieldToSearch = [Search String]
 
How do I set up a select query that prompts the user for a string and then
searches TWO or more fields (columns) for ocurrences of the input string? I
know how to do a query if I only need to search for the input string in ONE
field (column) of the database. Any thoughts?
Click to expand...

Just put the prompt in square brackets under each field that you want
to search, on *different* lines in the query grid so it uses OR logic.

John W. Vinson[MVP]
 
Back
Top