Is It Possible to Have Details Among Two Report Groupings?

[scottpw via AccessMonster.com]

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

 

[Duane Hookom]

You should be able to do this with a main report based on position and two
subreports for funding source and employees. To get totals in the main
report, it is often best to create two totals queries Count of funding
sources by position and Count of employees by position. Join these two totals
queries into the record source of your main report.

 

[vadimkra]

I got issue with groupings. I have the following table that represents
the manufacturing assemblies:

part name sub1 sub2 sub3 sub4

a partA D
b partB C D
c partC D
d partD

The meaning: D is a main assembly, C is a subassembly that goes into D,
B goes into C which goes into D.
All subs are also listed as parts.

I manage to create query of the form:

part, name, sub1, name1, sub2, name2, sub3, name3, sub4, name4

I make a report that groups the parts by subs in form:

sub4 sub3 sub2 sub1 part name

D
A partA
C partC
C
B partB


What I want is to add name to a group, that is have the output in form
of:

sub4 name4 sub3 name3 sub2 sub1 part name
D
partD

D partD
-----------------------------------------------------------------------------------------------------
A
partA
C
partC
---------------------------------------------------------------------------------------------------
C partC
B
partB


Since Access doesn't allow to create multiple grouping I can figure out
how to do this.

Thanks

Vadim K

 

[scottpw via AccessMonster.com]

Thank you for the insight.

Scotty

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

 

[scottpw via AccessMonster.com]

Thank you for the insight.

Scotty

I got issue with groupings. I have the following table that represents
the manufacturing assemblies:

part name sub1 sub2 sub3 sub4

a partA D
b partB C D
c partC D
d partD

The meaning: D is a main assembly, C is a subassembly that goes into D,
B goes into C which goes into D.
All subs are also listed as parts.

I manage to create query of the form:

part, name, sub1, name1, sub2, name2, sub3, name3, sub4, name4

I make a report that groups the parts by subs in form:

sub4 sub3 sub2 sub1 part name

D
A partA
C partC
C
B partB

What I want is to add name to a group, that is have the output in form
of:

sub4 name4 sub3 name3 sub2 sub1 part name
D
partD

D partD
-----------------------------------------------------------------------------------------------------
A
partA
C
partC
---------------------------------------------------------------------------------------------------
C partC
B
partB

Since Access doesn't allow to create multiple grouping I can figure out
how to do this.

Thanks

Vadim K

You should be able to do this with a main report based on position and two
subreports for funding source and employees. To get totals in the main

[quoted text clipped - 48 lines]