I have a database with customers, jobs and technicians. (There is composite key containing CustID, TechID and JobID to link these fields. Each job has 2 technicians. Is it possible to create a query showing a list of who a particular technician has worked with in the last month?

Thank You.