I got a "data type mismatch in criteria expression" error when i execute this statement
i can't figure what is wrong with this statement!!Code:sql = "insert into jobs(shift,[date],user,prq,prtotal,prtwt)" & _ " select prshift,format(prdate,'dd/MM/yyyy'),pruser,prtotal, "& _ "prQueuename, prTWT from preptbl where pruser = '" & Me.cboname.Text & "' and " & _ "prdate=#" & Format(DTP.Value, "MM/dd/yyyy")& "# and prQueuename= '" & Me.txtQ.Text & "'"