Count 1, 2, 3 down a report

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

Guest

I have a report of students that took a class. In my query it shows their name/ssn and what course the took (along with the credit they received)

How do I make the report count down the side of each like
1. Adam
courses/credi
2. Johnso
courses/credi
3. Smit
courses/credi
courses/credi
etc.....

I would really like to count the name at the top of the report (I counted how many times a class was taken (=count(courseNum)) and I summed the credit given (=sum(credit)), but when I try to count the SSN or count the NAME, it gives me the number of times that the SSN or name showed up in the query which is equal to how many courses were given

Thanks in advance.
 
One easy way is to add a group header.
Basically, in the details section you'd have the fields
for courses/credit. In the header, add the student's
name field.

Mike D.

-----Original Message-----
I have a report of students that took a class. In my
Click to expand...
query it shows their name/ssn and what course the took
(along with the credit they received).
How do I make the report count down the side of each like:
1. Adams
courses/credit
2. Johnson
courses/credit
3. Smith
courses/credit
courses/credit
etc......

I would really like to count the name at the top of the
Click to expand...
report (I counted how many times a class was taken (=count
(courseNum)) and I summed the credit given (=sum
(credit)), but when I try to count the SSN or count the
NAME, it gives me the number of times that the SSN or
name showed up in the query which is equal to how many
courses were given.
 
Create a textbox next to the name. Set the control source to =1 and set the
RunningSum property to either Over Group or Over All, depending.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Tony said:
I have a report of students that took a class. In my query it shows their
Click to expand...
name/ssn and what course the took (along with the credit they received).
How do I make the report count down the side of each like:
1. Adams
courses/credit
2. Johnson
courses/credit
3. Smith
courses/credit
courses/credit
etc......

I would really like to count the name at the top of the report (I counted
Click to expand...
how many times a class was taken (=count(courseNum)) and I summed the credit
given (=sum(credit)), but when I try to count the SSN or count the NAME, it
gives me the number of times that the SSN or name showed up in the query
which is equal to how many courses were given.
 
Back
Top