I need to figure out a way to show a running total that restarts whenever a certain field changes. For example, I have the following fields:

Page Number

Space

I'd like to show a running total of the Space field, but have that total restart whenever the page number changes (assuming that all records are sorted by page).

I've tried using a summary field, with the options of Total Of Space, Running Total, Restart Summary for each sorted group when sorted by page, but can't seem to get it to work.

Anyone have any suggestions and/or advice? Thanks!

Never mind- I found the issue (after much hair pulling). I was sorting on a related page number field, not the page number field I had set in the options for my summary field.

Funny how you can spend hours on an issue, not find an answer, post a topic asking for advice, and then all of a sudden figure it out...