NyQuiLlama
IS-IT--Management
Hopefully I can get some help here with my first post, go easy on me, I'm a relative SQL newb.
Here's the situation, I need to output a weekly report for a College that requires data from one table and two queries. I need it to simply report some totals or "head counts." I need to know how to make a report that just spits out the total number of fields in one table and does some simple math with some other fields. It needs to be sorted accross 4 campuses and look like this (I put comments in parenthatsis for more detail)...
Weekly Enrollmet Report
------------------------------------
Campus 1: (sorted by [CampusCode])
Current Students: 174 (this is just the total number in the table [CurrentStudents] by student ID [SSN])
Enrollments: 320 (sum of numerical field [TotalCredits] in same table [CurrentStudents] divided by 4)
Orientation total: 22 (this is the total number in a query [qOrientation] by student ID [SSN])
Accepted total: 13 (this is the total number in the same query [qOrientation] with a [DecCode] that reads "10" which means accepted)
Marketing Totals: (this is from a field in the 2nd query [qRecruits] that asks "How did you hear about us?"
Web = 15 (this is the total number of students with "Web" in the [Source] field)
Paper = 3 (this is the total number of students with "Paper" in the [Source] field)
etc....
then on to the next campus...
---------------------------------------------
Any suggestions or help in any way would be VERY much appreciated.
Thanks!!
Here's the situation, I need to output a weekly report for a College that requires data from one table and two queries. I need it to simply report some totals or "head counts." I need to know how to make a report that just spits out the total number of fields in one table and does some simple math with some other fields. It needs to be sorted accross 4 campuses and look like this (I put comments in parenthatsis for more detail)...
Weekly Enrollmet Report
------------------------------------
Campus 1: (sorted by [CampusCode])
Current Students: 174 (this is just the total number in the table [CurrentStudents] by student ID [SSN])
Enrollments: 320 (sum of numerical field [TotalCredits] in same table [CurrentStudents] divided by 4)
Orientation total: 22 (this is the total number in a query [qOrientation] by student ID [SSN])
Accepted total: 13 (this is the total number in the same query [qOrientation] with a [DecCode] that reads "10" which means accepted)
Marketing Totals: (this is from a field in the 2nd query [qRecruits] that asks "How did you hear about us?"
Web = 15 (this is the total number of students with "Web" in the [Source] field)
Paper = 3 (this is the total number of students with "Paper" in the [Source] field)
etc....
then on to the next campus...
---------------------------------------------
Any suggestions or help in any way would be VERY much appreciated.
Thanks!!