sql server - SQL query assistance needed with 'NOT' -

i'm working out of vb6 sql server 2012. found myself in pickle. have query works fine , pulls necessary data in sql server, however, i'm having difficult time translating vb6 sql code. here's working query in sql server...

select 'totalsum' = sum(units)   tbldetail  memberid = '117'       , cast(sstartd datetime) >= '4/1/2016'       , cast(sstartd datetime) <= '4/7/2016'       , service = 166       , [code] in('1919')       , not(invoiceno = '11880'             , dtlno = 2             )       , not(invoiceno = '11880'             , adjno = 2             ); 

so when try write in vb6 application like

select 'totalsum' = sum(units)   tbldetail  memberid = '117'       , cast(sstartd datetime) >= '4/1/2016'       , cast(sstartd datetime) <= '4/7/2016'       , service = 166       , [code] in('1919')       , (invoiceno <> '11880'           , dtlno <> 2          )       , (invoiceno <> '11880'           , adjno <> 2          ); 

however, not giving me same results. whats happening in last 2 clauses

( invoiceno <> '11880' , dtlno<> 2) , (invoiceno <> '11880' , adjno <> 2) 

when run them in sql server don't have paranthesis , absolutely detrimental 2 seperate clauses in paranthesis. know can do? think last resort might create store procedure don't want that.

edit:

g_sql = "select 'sum' = sum(units) " & _         "from tbldetail " & _         "memid = " & udtcdtl.lines(udtcdtlidx).memid & " , " & _         "cast(sstartd datetime) >= '" & startdate & "' , " & _         "cast(sstartd datetime) <= '" & dateadd("d", -1, enddate) & "' , " & _         "service = 166 , " & _         "[code] in (‘1919’)) , " & _         ("invoiceno <> " & invoicedtlrs!invoicehdrno & " or " & _         "dtlno <> " & (invoicedtlrs! invoicedtlno, "")) & " , " & _         ("invoiceno <> " & invoicedtlrs!invoicehdrno & " or " & _         "adjno <> " & invoicedtlrs! invoicedtlno) 

this should work. i'm able use sql queries using not adodb in vb6.

g_sql = "select 'sum' = sum(units) " & _     "from tbldetail " & _     "memid = " & udtcdtl.lines(udtcdtlidx).memid & " , " & _     "cast(sstartd datetime) >= '" & startdate & "' , " & _     "cast(sstartd datetime) <= '" & dateadd("d", -1, enddate) & "' , " & _     "service = 166 , " & _     "[code] in ('1919')) , " & _     "not (invoiceno = " & invoicedtlrs!invoicehdrno & " , dtlno = " & invoicedtlrs!invoicedtlno & ") , " & _     "not (invoiceno = " & invoicedtlrs!invoicehdrno & " , adjno = " & invoicedtlrs!invoicedtlno & ")"