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.
 

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

Back
Top