I need some help figuring out how to Create a query for an access database. The data is in two table "Employees" and "Trips". Employees contains 3 simple columns ID, FirstName, LastName; Trip contains Date, TripID, Emp1, Emp2, Emp3, Outcome.
I need to create 2 Reports. First is a report that is a list of Employees and under each employee it should like each outcome and a count of the trips with that outcome. Second is a list of TripID with each Employee that was assigned to it.
What is the best way to accomplish this?
I really need this urgently, thanks everyone.