Counting Records for a report

[RonMcIntire]

All:

I have a table with 2000 MemberIDs spread out over 60 ChapterNo's. At print time, I print a separate report for each chapter that includes the number of memberIDs in that specific chapter. This looks like run-of-the-mill stuff but I'm lost. I'm using Access 2003.

My original thought was to put an SQL statement in the report Detail_Format section but I'm not sure if this is the way to go.

The table looks like this:

ChapterNo MemberID
A-101 105973
A-101 109755
A-101 106973
A-105 109931
A-105 105473
A-115 105938
A-115 177983

Can anyone help or point me in the right direction?

Ron

 

[dhookom]

help or point me in the right direction

Help do what? Apparently you already know how to get the number of records in a report.

for each chapter that includes the number of memberIDs

Duane
Hook'D on Access
MS Access MVP

 

[RonMcIntire]

Sorry, I thought I had been more clear than that. Maybe I should have asked in the last sentence for some help with an SQL statement that would work.

 

[dhookom]

SQL statement that would work" to do what?
It's great that you provided some sample records but you haven't stated exactly what you would like displayed in your report and where you want it displayed (unless I missed something)

Duane
Hook'D on Access
MS Access MVP