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

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thank you for the insight.

Scotty

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

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]
Thanks
Scotty

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200701/1

.