Is It Possible to Have Details Among Two Report Groupings?

I am attempting to report employee position numbers and their respective
associated funding sources within a report. There can be multiple funding
sources for any particular position; hence I need funding reflected within
"details." Then beneath the position and its funding details; I need to
establish another grouping reflecting one or more employees appointed to the
position (in other words, a multi-filled position); hence any number of
employees are within "details." While I can group funding details, it may
create duplication of employees' names within multiple funding sources; and
therefore, I am unable to establish a rolling count of employees accurately.
This is a diagram of what I need:

Group 1: Position Number:
Detail 1: Funding Source A
Detail 1: Funding Source B
Detail 1: Funding Source C

Sub Group 2: Assigned Employees:
Detail 2: Employee A
Detail 2: Employee B

Total Positions: 1
Total Funding Source: 3
Total Employees: 2


Group 1: Position Number:
Detail 1: Funding Source D
Detail 1: Funding Source E

Sub Group 2: Assigned Employees:
Detail 2: Employee C
Detail 2: Employee D
Detail 2: Employee E

Total Positions: 1
Total Funding Source: 2
Total Employees: 3

Grand Total Positons: 2
Grand Total Funding Source: 5
Grand Total Employees: 5

Thanks
Scotty

--
Message posted via http://www.accessmonster.com

.

Relevant Pages