Access VBA Error 3075 -

i running access 2016 , trying records query. access noob , making database. when run following code, error 3075, , says operator not there, thing is, when paste sql code access query runs fine, cant see problem

    sub dothings()  dim integer dim array1() variant dim array2() variant  dim dadb dao.database set dadb = currentdb   '' getting temp vars first dim vend string vend = cstr([tempvars]![temp1]) '' these temp vars access application  dim loc string loc = cstr([tempvars]![temp2])  msgbox ("vendor is: " & vend & " , location is: " & loc) 'setting sql statement dim qry string 'sql statement query qry = "select [table1].scanid, [table2].fieldv, [table1].[fielda], [table1].[fielde], (([table1]![fielde])/([table1]![fielda])) v, [table1].[qr code], [table3].[selected?], [table3].[location recieved], [table3].[travel notes] ([table2] inner join [table1] on [table2].batchid = [table1].batchid) inner join [table3] on [table1].scanid = [table3].scan_id **where ((([table2].fieldv) = " & vend & ") , (([table3].[location recieved]) = " & loc & ") , (([table3].[date shipped]) null)) order (([table1]![fielde])/([table1]![fielda])) desc;**" dim daqdf dao.querydef 'first query find , select actual datapoints." set daqdf = dadb.createquerydef(qname, qry)  dim dars dao.recordset 'getting recordset setup set dars = daqdf.openrecordset(qname, dynaset) 

so error getting says statement wrong, cant see problem. source of error somewhere else?

this error statement getting:

can tell me how can fix this? or cause of problem is?