Multi-Column report

  • Thread starter andy_42 via AccessMonster.com
  • Start date

A

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!
 
Ad

Advertisements

B

Bob L.

* andy_42 via AccessMonster.com said:
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
 
A

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!
 
A

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?
 
B

Bob L.

* andy_42 via AccessMonster.com said:
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
 
Ad

Advertisements

A

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top