Creating Org Charts in an Access Report?

[Guest]

Can I use Access to create an org chart from my employee database? Each
employee is assigned a role. I envision a report that contains the results
of multiple queries on one page (for example, the employee name and phone
assigned to each role). My goal is to eliminate the number of documents I
have to update every time we have a change in staff, such as both the org
chart and phone list.

 

[Linda Burnside]

You might try building an organization chart in Word, and use fields instead
of names in your chart. To see your organizational chart, run a Word merge
(something is possible to do directly from Access using VBA code).

I would say use Word o ver the Access report because Word is a better tool
for making all those little boxes and lining them up. Of course, the best
tool for organization charts is Visio, but I have no experience making it
work with Access.


Linda

 

[Duane Hookom]

I agree regarding Visio. There is at least one version that has a Org Chart
builder that can link to your table of employees.