a different kind of report needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

So far, I've seen reports that are directly out of a MADE querry. However,
what I need is a report that is more of a summary

How many students were this kind, that kind... and so forth. I've yet to
find anything that would help me.

Is there a command that I am missing? Would the summary have to show in the
report footer?

Please help!!!
 
hi,
first you have to write a query that will tell you how
many students were this kind, that kind... and so forth.
use the totals aggragate function count.
 
Create a query that includes StudentID and student type. Click on the Sigma
(looks like E) on the tolbar at the top of the screen. Under StudentID
change Group By to Count. This query wiil give you the count of each student
type. When you usew this query in your report, note that the StudentID field
is now CountOfStudentID.
 
Back
Top