Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Location
    Summerville, South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Organizational Chart (Access 2000)

    Just curious if anyone has ever tried to create an organizational chart as a report within Access. I only need to go down 3 levels. For example, Senior management is level 1, manager is level 2 and supervisor is 3. Everyone else below that is 4. I want to track positions in Access and print out a chart that shows where each person is in the group.

    Any help would be great.

    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Organizational Chart (Access 2000)

    Wouldn't grouping suffice in a report? Using a field that determins which level a person works at should allow you to create your groups.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Organizational Chart (Access 2000)

    If you have Visio, its Organization Chart Wizard can read data from an Access database - see Make Microsoft Visio 2000 Organization Charts from Personnel Files.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Organizational Chart (Access 2000)

    I saw this interesting Access MDE called Virtual Hierarchy It is in A97 and 2000 versions and looks quite useful, I have been playing with it and have just got to get used to its little quirks but it is <img src=/S/free.gif border=0 alt=free width=30 height=15>
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •