Opps. That's what I get for Copy and Paste. Continuing on this sub, here is an new one. It initially said that I could not GROUP BY when using a SELECT *. So I changed to individual fields.
Code:
strRptSQL1 = "SELECT OrderNo, SKU, Date_Time, SKUQty, Process, ContractCo FROM WOTracking WHERE ContractCo = '" & Me.cbxContractCo & "' AND Date_Time >= #" & Format(dt1, "yyyy-mm-dd") & "# AND Date_Time < #" & Format(dt2, "yyyy-mm-dd") & "# GROUP BY OrderNo;"
Set rs = db.OpenRecordset(strRptSQL1)
Now I get: The query does not include the specified expression 'SKU' as part of an aggregate function.