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!

Does'nt like - Not Like 1

Status
Not open for further replies.
ftook

ftook

Programmer
Dec 4, 2006
80
GB
I need to filter all Flint* type door styles but I can't seem to get the Not Like working as below :

If (Me.slw < 740 And Me![Door Style] not Like "Flint*") Or Me.slw > 900 Then

gives expected : expression

any ideas please ?
 
Sort by date Sort by votes
How are ya ftook . . .

. . . and this:
Code: 
[blue]
If (Me.slw < 740 Or Me.slw > 900) And Not (Me![Door Style] Like "Flint*")  Then[/blue]

Calvin.gif
See Ya! . . . . . .
 
Upvote 0 Downvote
Needed to change slightly - but great thanks TheAceMan1 - great feedback.

If (Me.slw < 740 And Not (Me![Door Style] Like "Flint*")) Or Me.slw > 900 Then
 
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
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
784
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
970
TrekBiker
TrekBiker
applestoapples
  • Locked
  • Question
Make Table Query sort not working 1
Replies
2
Views
345
Andrzejek
Andrzejek
iamchemist
  • Locked
  • Question
&quot;Access Application Not Responding&quot; Message
Replies
1
Views
239
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top