getting "missing operator in sql query" anyon egot an idea?






sSQL1 = "SELECT * FROM [Service Calls] WHERE [Service Calls.Date] BETWEEN #" & sDateFrom & "# AND #" & sDateTo & "# INNER JOIN [Service Calls] ON [Customer Info.Cust ID Number] = [Service Calls.Cust ID Number] SORT BY Date,Time"