N
Nathan Lars
Your knowledge and help would be very appreciated.
I have a db to keep track of projects and their status towards completion.
I need to create a summary report that that shows the number of projects for
each department and the number of these same projects and what
phase(Requested, Assessment, RFP...). So the the total number of projects
can be displayed so that you can quickly see the number of projects for each
department for each phase. It would look somthing like this:
Requested Assessment RFP Execution Completed
Totals
Dept.1 6 3 3 5
8 25
Dept.2 1 1
4 6
Dept.3 2 4 6
12 24
Totals 9 4 7 11
24 110
The top row and side columns are 2 Combo Boxes on the project db Form. The
project phases would be across the top and who the project is for would be
listed on the left side. So if a project on the Form has "Dept.2" selected
in one Combo Box and "Assessment" selected on the other Combo Box, the
Crosstab Query would show it. Likewise, if Dept.2's project in the Requested
phase was moved to the Assessment phase, Dept.2's Requested number field
would be empty and it's Assessment Field would show a total of 2.
My problem is that I can't get the Departments to list as rows along the
left side of the Crosstab Query. Am I not using the crosstab correctly?
Should I be going about this diffently? You are dealing with someone who has
a basic understanding of access but is eager to learn.
Once this is done I would like to set up hyperlinks for each field total to
allow you to drill down to more reports for greater details if needed.
I have a db to keep track of projects and their status towards completion.
I need to create a summary report that that shows the number of projects for
each department and the number of these same projects and what
phase(Requested, Assessment, RFP...). So the the total number of projects
can be displayed so that you can quickly see the number of projects for each
department for each phase. It would look somthing like this:
Requested Assessment RFP Execution Completed
Totals
Dept.1 6 3 3 5
8 25
Dept.2 1 1
4 6
Dept.3 2 4 6
12 24
Totals 9 4 7 11
24 110
The top row and side columns are 2 Combo Boxes on the project db Form. The
project phases would be across the top and who the project is for would be
listed on the left side. So if a project on the Form has "Dept.2" selected
in one Combo Box and "Assessment" selected on the other Combo Box, the
Crosstab Query would show it. Likewise, if Dept.2's project in the Requested
phase was moved to the Assessment phase, Dept.2's Requested number field
would be empty and it's Assessment Field would show a total of 2.
My problem is that I can't get the Departments to list as rows along the
left side of the Crosstab Query. Am I not using the crosstab correctly?
Should I be going about this diffently? You are dealing with someone who has
a basic understanding of access but is eager to learn.
Once this is done I would like to set up hyperlinks for each field total to
allow you to drill down to more reports for greater details if needed.