I am trying to setup a query that will allow me to see all users who have the same manager. The "manager" is not a constant value, but one that change as new users are added to the database. The end goal is to be able to send an Outlook email to the one manager, while CC'ing each user. My database will be handling large data sets and simply emailing each individual user will not be efficient.