criteria search in 2 different fields

  • Thread starter Thread starter accesscrzy
  • Start date Start date
A

accesscrzy

I want to ask the user to input one keyword and search two
different fields in the same table. Any suggestions?
 
PARAMETERS [Keyword?] AS Text;
SELECT *
FROM Table_Name
WHERE Column1 = [Keyword?] OR Column2 = [Keyword?]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple "Ors" in query 2
SQL. keyword search in 3 tables. 6
Access Dcount (multiple criteria) 3
Populate Dropdown combo from multiple tables 0
Using a field reference in a query critereon 0
Parameter query searching multiple fields 5
Multiple tables search 3
Input one criteria for searching 5 fields containing the same data 5

Back
Top