[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

Chart type report in Access 2003

I think this to be one of the hardest questions I will ever ask.

I would like a report that display all the names of personnel assigned to a division on the left hand side of letter paper, landscaped, going from top to bottom and a list of all the PQS's we have going across the top.  Then placing a C in a box where the person completed the PQS, an A where they are assigned or an I where it's in-Progress.  Is this possible in Access 2003? If so How?

Thank you
John
0
John Sheehy
Asked:
John Sheehy
  • 2
1 Solution
 
Helen FeddemaCommented:
This sounds like an excellent candidate for a PivotTable report.  First make a query containing just the fields you need in the report, including the C and A as calculated fields, then make a PivotTable based on it.  See my Access Archon articles on PivotTables and PivotCharts -- it was written for Access 2002, so you will have a few more features available in Access 2003, but the basic principles are the same.
Here are links to download these articles (including a sample database):
http://www.helenfeddema.com/Files/accarch86.zip
http://www.helenfeddema.com/Files/accarch87.zip
And here is a screen shot of a PivotTable:
PivotTable.jpg
0
 
Helen FeddemaCommented:
BTW, PivotTables and PivotCharts are an exception to the general rule that it is not a good idea to print forms -- if you don't need report headers or footers, you can just print the forms; if you do need report headers/footers, use a subform/subreport control with the PivotTable form as its source object.
0
 
John SheehySecurity AnalystAuthor Commented:
Sorry it has tken me so long to get back, I have been away for the past two days.  I am looking at your possible solutions now and will return in a bit with any questions I may have.  Thanks
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now