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

SELECT QUERY - NOT TO INCLUDE TWO STATE 1

Status
Not open for further replies.
DantheDbaseMan

DantheDbaseMan

Programmer
Mar 16, 2000
11
US
How do you write in the criteria if you want to select all address records in the United States except Oregon and Texas?

 
Sort by date Sort by votes
where [State] <> &quot;Oregon&quot; and [State] <> &quot;Texas&quot; Maq B-)
<insert witty signature here>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
344
dhookom
dhookom
Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
405
rashmibala
R
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
551
mikrom
mikrom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
844
strongm
strongm
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino

Part and Inventory Search

Sponsor

Back
Top