create report in access of stepped related lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003

My database has a list of managers, each of whom are responsible for a
number of groups of employees in each one's areas. I want to produce a report
which shows each manager, then a list of the groups each is responsible for,
with the names of each person in those groups (these would be presented in a
stepped form). Ideally I would have a parameter statement in which I can
specify the manager and produce a report of the groups and people under that
manager. All my attempts at queries/select queries/forms have resulted in
only returning common data or combined in a way that doesn't mean anything. I
suspect the answer is in Select Queries but don't have enough technical
knowledge.
 
if your tables are built and related correctly, that should be an easy
query, with the grouping done at the report level. how about starting by
posting the SQL statement from the report's underlying query, so we can see
it.

hth
 
Thanks Tina,
I have not been able to produce a query that provides the information for a
report. My organisation has managers each of whom have staff and clients
responsible to them. I can produce a query that shows each manager with each
of their staff, OR each of their clients. I can produce a Union Query which
combines both staff and clients. But I cannot produce one which says Manager,
Staff (Label) & List of names, step, Client (label) & list of clients. I
suspect there is some syntax in the query grid or select statement that I am
unaware of that will make the differentiation.
 
Thanks Tina,
I have not been able to produce a query that provides the information for a
report. My organisation has managers each of whom have staff and clients
responsible to them. I can produce a query that shows each manager with each
of their staff, OR each of their clients. I can produce a Union Query which
combines both staff and clients. But I cannot produce one which says Manager,
Staff (Label) & List of names, step, Client (label) & list of clients. I
suspect there is some syntax in the query grid or select statement that I am
unaware of that will make the differentiation.
Click to expand...

This would be very difficult in a Query.

It would be dead easy on a Report (which is what you want anyway, I'm
guessing): a Report based on the tble of managers, with two
Subreports, one based on Staff, the other based on Clients.

Sometimes it helps to use a different tool - you can drive nails with
a wrench, but that doesn't make it a hammer.

John W. Vinson[MVP]
 
well, as John says, and as i said previously, do it at the report level, not
at the query level.

hth
 
Thanks John & Tina,

Subreports is something new to me, not a concept that I have been aware of,
so I will chase the help screens around and if I have no joy will get back to
you.

Regards
 
Back
Top