Difficult "Select Query" in Access

C

CSPerez

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

Jason Byrnes

SELECT * FROM yourTable WHERE fieldToSeach = [Search String] OR
otherFieldToSearch = [Search String]
 
J

John Vinson

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]
 
Top