Results 1 to 2 of 2
  1. #1
    pooldead is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    26

    Querying Users by their Manager

    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.

  2. #2
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Depending on how your tables are set up a Group By query should do the trick. Just Group By Managers and it will be dynamic based on Manager\Employee changes.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 02-15-2018, 03:11 AM
  2. Switchboard Manager Add-In
    By dwwally in forum Access
    Replies: 2
    Last Post: 01-03-2017, 12:52 PM
  3. Multiple users querying linked tables
    By vadnagra in forum Import/Export Data
    Replies: 6
    Last Post: 09-21-2016, 01:31 PM
  4. Need Employee Manager
    By gentikfreak in forum General Chat
    Replies: 1
    Last Post: 01-29-2013, 09:00 AM
  5. Report Manager
    By OldCityCat in forum Programming
    Replies: 4
    Last Post: 07-27-2012, 01:19 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums