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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Criteria

Status
Not open for further replies.
Cia2a

Cia2a

Technical User
Aug 8, 2000
23
US
In my priority field I have 5 different priorities, 1 - Critical, 2-Impact, 3-work around and such. I want to pull all records for priorities 2 and 3. How do I put this in the Criteria field on my query?.

Thanks in advance.
 
Sort by date Sort by votes
Hi

= 2 or = 3

or

In (2,3)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
 
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
287
Swi
Swi
TrekBiker
  • Locked
  • Question
Select addresses using two criteria, one 'Like" 2
Replies
3
Views
133
TrekBiker
TrekBiker
qqp
  • Locked
  • Question
Query criteria from form
Replies
9
Views
210
qqp
qqp
SoLost1
  • Locked
  • Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
143
dhookom
dhookom
lmcate
  • Locked
  • Question
Access Report - Save Report to multiple PDF's for each of the vendors 1
Replies
17
Views
366
Uncle Gizmo
Uncle Gizmo

Part and Inventory Search

Sponsor

Back
Top