where clause help

  • Thread starter Thread starter Lee-Anne Waters via AccessMonster.com
  • Start date Start date
L

Lee-Anne Waters via AccessMonster.com

HI,

this is what i have just far in a procedure on a form.

strSQL = "select * from tmpDispatch " _
& "WHERE PreferedMethod = '2'"

however, i cant figure out how i would write in a 2nd where clause. i want to
exclude all records where the workype field = jumper

thanks

Lee-Anne
 
Lee-Anne Waters via AccessMonster.com said:
HI,

this is what i have just far in a procedure on a form.

strSQL = "select * from tmpDispatch " _
& "WHERE PreferedMethod = '2'"

however, i cant figure out how i would write in a 2nd where clause. i
want to exclude all records where the workype field = jumper
Click to expand...

strSQL = "select * from tmpDispatch " _
& "WHERE PreferedMethod = '2' " _
& "AND WorkType <> 'jumper'"
 
many thanks :)

Rick said:
HI,
Click to expand...
[quoted text clipped - 5 lines]
however, i cant figure out how i would write in a 2nd where clause. i
want to exclude all records where the workype field = jumper
Click to expand...

strSQL = "select * from tmpDispatch " _
& "WHERE PreferedMethod = '2' " _
& "AND WorkType <> 'jumper'"
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

where clause help 2
Go To Command 9
OpenReport Macro Problem 3
Where clause with 2 criteria 6
WHERE clause 5
strSQL as String 3
build the where clause... 5
Syntax for "OR" in WHERE clause passing parameters from C# ASP.NET 6

Back
Top