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

everything but in a criteria 2

Status
Not open for further replies.
logopolis

logopolis

Technical User
Oct 10, 2002
59
ES
is there a way to set a criteria to show everything but one type of entry in a field in a query.

John
 
Sort by date Sort by votes
Use <> preceding your criteria.

Text Field Example:
<>"YourCriteria"

HTH,
Eric
 
Upvote 0 Downvote
Yeah, Luceze is right. Here are some other examples...

<>"Charlie Brown"
<> 123
<> true
<> #1/1/1999#
<> Forms![abc]![text1]

The last example bars whatever value is in the text field "text1" in the form "abc".
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
3K
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
689
PrimoSteve
PrimoSteve
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
442
Xavierparkash
Xavierparkash
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top