Hi Guy's, i have a query saved that runs OK when Running Query, (prompted to put date in), when i run it through VBA it won't run
Too Few Parameters Expected 1 Run Time Error 3061
sDelTo is a specific DelTo to avoid
Is it when i am using Not In ? i know double quotes are needed but also trying exclude Delivery or Collection In the status ?
So target is Exclude > sDelTo Exclude > Delivery > Exclude Collection
It runs fine when trying Query25 with a prompt to add date (week start)
Code:
strSQL3 = "SELECT tblEdit.DelTo, tblEdit.Town, tblEdit.PostCode, tblEdit.ItemType, tblEditItemNo, tblEdit.SONumber, tblEdit.TotalBox, tblEdit.TotalItem, tblEdit.Status, tblEdit.ShipmentDate " _ & "From tblEdit " _
& "WHERE (((tblEdit.DelTo)<> '" & sDelTo & "') AND ((tblEdit.Status) Not In (""Delivery"",""Collection"")) AND ((tblEdit.ShipmentDate)= [Forms]![frmPlanning]![cboWeek]));"