Re: Is It Possible to Have Details Among Two Report Groupings?

If you have field names like sub1 sub2 sub3 sub4 then I suggest you normalize
your table structure. You should also start a new thread (possibly in
tabledbdesign for recommendations regarding normalization) since the OP
question is dealing with normalized tables.
--
Duane Hookom
Microsoft Access MVP


"vadimkra" wrote:

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






Duane Hookom wrote:
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.
--
Duane Hookom
Microsoft Access MVP


"scottpw via AccessMonster.com" wrote:

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

  • Re: Is It Possible to Have Details Among Two Report Groupings?
    ... I make a report that groups the parts by subs in form: ... subreports for funding source and employees. ... To get totals in the main ... sources by position and Count of employees by position. ...
    (microsoft.public.access.reports)
  • Re: refer to a summarised field which doesnt appear on the report
    ... To display the totals, ... name of the report that contains your totals. ... I have a separate report which does count the number of employees at each ... > locality. ...
    (microsoft.public.access.reports)
  • Is It Possible to Have Details Among Two Report Groupings?
    ... I am attempting to report employee position numbers and their respective ... There can be multiple funding ... establish another grouping reflecting one or more employees appointed to the ... Detail 1: Funding Source B ...
    (microsoft.public.access.reports)
  • RE: Automatically add and subtract
    ... Monthly Totals page ... Cell A1 has the number 5 typed in it. ... To eliminate the need for key punching the employees numbers attained each ... The base program is in a folder. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Automatically add and subtract
    ... Monthly Totals page ... Cell A1 has the number 5 typed in it. ... To eliminate the need for key punching the employees numbers attained each ... The base program is in a folder. ...
    (microsoft.public.excel.worksheet.functions)