Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Searching Several Columns 1

Status
Not open for further replies.
SShefer

SShefer

Technical User
Aug 7, 2001
20
US
How do I make it so that a query searches several columns for the same piece of info?

thanks
 
Sort by date Sort by votes
In your query, put your search criteria in the criteria box for each field.

Just make sure you cascade the entries so the Or operator is used instead of And. This will return all rows for all fields that begin with what the user enters...

HTH
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
616
Swi
Swi
03Explorer
  • Locked
  • Question
Pivot with custom header columns 1
Replies
5
Views
94
dhookom
dhookom
Lavenderchan
  • Locked
  • Question
Help with finding Max Value for 4 columns with if statement
Replies
10
Views
144
Andrzejek
Andrzejek
N2Life
  • Locked
  • Question
Microsoft Access 2016 Insert Columns while using Query Design
Replies
6
Views
756
N2Life
N2Life
airwolf09
  • Locked
  • Question
ACCESS 2010 SQL Columns to Rows
Replies
7
Views
118
airwolf09
airwolf09

Part and Inventory Search

Sponsor

Back
Top