By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,945 Members | 1,648 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,945 IT Pros & Developers. It's quick & easy.

counting unduplicated student IDs

P: n/a
Thanks for the hint Allen (see below). But I am already doing that
count as total records read (5)in the report footer. That count is
unduplicated for the record not for the field - student ID as I've
indicated in my sample report. I really need an unduplicated count of
the student ID only. I guess my subject was not clear.

------------------------------------------------------------------------------
From: Allen Browne (Al*********@SeeSig.Invalid)
Subject: Re: counting unduplicated records
View: Complete Thread (2 articles)
Original Format
Newsgroups: comp.databases.ms-access
Date: 2004-11-21 18:00:13 PST

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!

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
mjobrien wrote:
Thanks for the hint Allen (see below). But I am already doing that
count as total records read (5)in the report footer. That count is
unduplicated for the record not for the field - student ID as I've
indicated in my sample report. I really need an unduplicated count of
the student ID only. I guess my subject was not clear.

------------------------------------------------------------------------------
From: Allen Browne (Al*********@SeeSig.Invalid)
Subject: Re: counting unduplicated records
View: Complete Thread (2 articles)
Original Format
Newsgroups: comp.databases.ms-access
Date: 2004-11-21 18:00:13 PST

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.


Create a group band on the StudentID. I'll assume its storted on the
StudentID. Then create a running sum field in that band.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.