How Do I Create A Report In Outline Format

Question

I am creating a database for our department's strategic plan. I have four tables:
1) Priorities
2) Goals
3) Milestones
4) Outcomes

I need to create a report that looks like the outline below. I figured out how to do the numbering system. I just can't figure out how to format a report that looks like this.

1. Priority
1.1 Goal
1.1.1 Milestone
1.1.1.1 Outcome
1.2 Goal
1.2.1 Milestone
1.2.1.1 Outcome
1.2.1.2 Outcome
1.2.2 Milestone
1.2.2.1 Outcome
2. Priority
2.1 Goal
2.1.1 Milestone
2.1.1.1 Outcome

MCFNeil · Answer

I'm assuming they are all related in a similar cascading order.

My recommendation is to explore a table report, but focus on the sort & grouping options. Play around with it, but you should be able to get that affect by grouping several items (low to high)

Priority, goal, milestone, outcome.

Sign up

Login to the community