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...
 
Back
Top