I'm sure there is a simple answer to this question but for the life of me I can't figure it out.
I would like to have 3 totals in the footer that are updated as soon as I enter a new record.
In the example I would like the the footer to show the number of Process Level 1, Process Level 2 and Process Level 3 as totals for each Process.
I can get a total of Process Levels, which helps but not categorized by Level Number.
How do I do this? Any help would be greatly appreciated.