counting unduplicated records

[mjobrien]

i am having the hardest time trying to get an unduplicated count of
student IDs from my report.

i have the following report
Student ID Term Hours
1111111 SU04 1.0
1111111 FA04 4.0
2222222 SU04 5.0
3333333 SU04 3.0
3333333 FA04 6.0

Total Unduplicated Count ??? (should be 3--count of unduplicated
student IDs)
Total records read 5 (OK---can get this)

it's probably simple but I seem to have tried almost everything. I
read about creating a sub report but I don't know how to do this or if
it will even solve my problem.

Help Help!

[Allen Browne]

Using the Sorting And Grouping dialog (View menu, from report design), add a
Group Footer section for StudentID.

In this section, and a text box with these properties:
Control Source =1
Running Sum Over All

This text box will accumulate the count of students. If you wish, you can
set its Visible property to no, and then put another text box into the
Report Footer section, and make it equal to that one.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mjobrien" <mj******@elcamino.edu> wrote in message
news:63*************************@posting.google.co m...

i am having the hardest time trying to get an unduplicated count of
student IDs from my report.

i have the following report
Student ID Term Hours
1111111 SU04 1.0
1111111 FA04 4.0
2222222 SU04 5.0
3333333 SU04 3.0
3333333 FA04 6.0

Total Unduplicated Count ??? (should be 3--count of unduplicated
student IDs)
Total records read 5 (OK---can get this)

it's probably simple but I seem to have tried almost everything. I
read about creating a sub report but I don't know how to do this or if
it will even solve my problem.

Help Help!