Creating the Query SalesbyRepQ you created an ad hoc relationship between OrderListQ, SalesRepID and EmployeeT, EmployeeID. Running the Query returns error message Type mismatch in expression.
noted that you didn't run the query. in the video,but i get the same error when I try to run the report SalesByRepR in print preview mode. I am using Access 2016.