Multi-Column report

[andy_42 via AccessMonster.com]

I apologize if this has been addressed but I can't seem find a good solution
and I'm not entirely sure of the reporting capabilities within access. What I
am trying to do is create a report as follows:


JobTitle District1 district2
Manager Name,Department name, department
Name, department

VP name, department
Clerk name, department name, department
---------------------------------------------------------------------

The goal is to have employees grouped by job title and by district so I can
review all employees with a specific title who are in a specific location.

My database simply lists employee information in a single table right now.
emp#,name,title,department,district,etc.

What I can do is create a crosstab report for titles and districts so I guess
the major problem is populating the name, department etc. under the correct
district and the correct title.

Can anyone offer a suggestion for approaching this? Any ideas are
appreciated.

Thanks!

 

[Bob L.]

I apologize if this has been addressed but I can't seem find a good solution
and I'm not entirely sure of the reporting capabilities within access. What I
am trying to do is create a report as follows:


JobTitle District1 district2
Manager Name,Department name, department
Name, department

VP name, department
Clerk name, department name, department
---------------------------------------------------------------------

The goal is to have employees grouped by job title and by district so I can
review all employees with a specific title who are in a specific location.

My database simply lists employee information in a single table right now.
emp#,name,title,department,district,etc.

What I can do is create a crosstab report for titles and districts so I guess
the major problem is populating the name, department etc. under the correct
district and the correct title.

Can anyone offer a suggestion for approaching this? Any ideas are
appreciated.

Thanks!

Why don't you just create a regular report (not a cross-tab) where you
group by District and then by Title, i.e. like this:

District xxxxx
Job title
Name 1
Name 2

The report wizard should help you do this.

Bob

 

[andy_42 via AccessMonster.com]

Why don't you just create a regular report (not a cross-tab) where you

group by District and then by Title, i.e. like this:

District xxxxx
Job title
Name 1
Name 2

This will definitely produce the data I need but how can I now display the
districts by column instead row?

District1 district2
district 3
Jobtitle1 name1, dept name2, dept


Jobtitle2 name3, dept name4,
dept.


If I were to output this to excel, it needs to have this format. Any thoughts?


Thanks!

 

[andy_42 via AccessMonster.com]

Essentially I need a way that I can select all employee information first
sorted by district to display by columns. From this data, I want to sort it
by job title. All of this nicely displayed in a report that I can export to
excel. Seems easy enough but I can't figure out how to display the districts
across columns as opposed to down rows.

Hope this makes more sense?

 

[Bob L.]

Essentially I need a way that I can select all employee information first
sorted by district to display by columns. From this data, I want to sort it
by job title. All of this nicely displayed in a report that I can export to
excel. Seems easy enough but I can't figure out how to display the districts
across columns as opposed to down rows.

Hope this makes more sense?

Andy,
I have never used it myself, but suggest you try using the form wizard
to create a pivot table. I think that will come close to what you want
and you can then export it to Excel I believe. I've now told you more
than I know!

HTH
Bob

 

[andy_42 via AccessMonster.com]

It looks like it would work but not very friendly for printing large all data
with the district columns side by side as I have them.

Districts (columns)
Job Title name,dept displayed under each district and beside the job title.
(rows)

I feel as though there is an easy answer to this but I might not be
explaining it the best.

Essentially I need a way that I can select all employee information first
sorted by district to display by columns. From this data, I want to sort it

[quoted text clipped - 3 lines]

Hope this makes more sense?

Andy,
I have never used it myself, but suggest you try using the form wizard
to create a pivot table. I think that will come close to what you want
and you can then export it to Excel I believe. I've now told you more
than I know!

HTH
Bob