what is the type mismatch for this expression INNER JOIN between tblService and tblSchedule SELECT tblService.Employee, tblSchedule.DateOfAppt, COUNT(tblService.ServiceName) AS TotalServices FROM tblService INNER JOIN tblSchedule ON tblService.ServiceName = tblSchedule.Service GROUP BY tblService.Employee, tblSchedule.DateOfAppt ORDER BY tblSchedule.DateOfAppt, COUNT(tblService.ServiceName) DESC