How to count records/student?

[Teacher_Lin]

Hi,

I have a table of records of students’ test scores. Each time a student takes a test, a new record is created. So, John may have taken 15 tests but Mary may have taken 16. I have not figured out how I can keep a running total of tests taken. I would be grateful if anyone can suggest a way to do this.

Thank you:)

[ScottWorld]

Group your records by student. Then, in the grey horizontal bar for each grouping, you will have the ability to choose summary fields for whichever fields you’d like to summarize.

[Teacher_Lin]

Yes, that does the job. Thank you.

[ScottWorld]

Glad I could help! :slightly_smiling_face: If you don’t mind, could you please mark my comment above as the solution to your question? This will help other people who have a similar question in the future. :slightly_smiling_face: