Trying my first inner join on a multitable query (below).
Code:
strRptSQL1 = "SELECT WOTracking.*, Inventory.BoxingType, Inventory.ProcessCode, FROM WOTracking INNER JOIN Inventory ON WOTracking.SKU = Inventory.SKU WHERE ContractCo = '" & Me.cbxContractCo & "' AND Date_Time >= #" & Format(dt1, "yyyy-mm-dd") & "# AND Date_Time < #" & Format(dt2, "yyyy-mm-dd") & "# ORDER BY OrderNo;"
I am getting an Error 3141 'SELECT includes a reserved wordor an argument name...'. I got this syntax from another forum, but am not sure exactly what I am looking for.
Any help would be greatly appreciated.