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

Not like

Status
Not open for further replies.
Rachel30

Rachel30

Programmer
Mar 1, 2005
95
GB
Hi,

I am trying to do a formula where you say if Field name like

ie Field Name Like "*10*"
How do I say not like

Thanks Rachel
 
Sort by date Sort by votes
Hi,
Use:
Code: 
not ({FieldName} like "*10*")

the Not operator negates the criteria following it..



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
389
lbass
lbass
Cpreston
  • Locked
  • Question
Remaining Text does not appear problem 2
Replies
10
Views
421
Cpreston
Cpreston
jlr123
  • Locked
  • Question
Boolean Formula = True/False Not Intended Value
Replies
3
Views
262
jlr123
jlr123
Cpreston
  • Locked
  • Question
Field not displaying in one line
Replies
1
Views
146
Cpreston
Cpreston
TMasterK
  • Locked
  • Question
Showing Duplicates but starting with the second character not the first (string)
Replies
1
Views
137
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top