Hello--I have a form with with a dynamic subform that the user can add
lines to with a button.Within each line of the repeating subform is a
dropdown named category and a numeric box named hours.Throughout the day
the user will add a line for each task they perform, select the category
and input total hours.I would like to create a total hours by category
in the footer to sum up all the hours for each category that day.If I
was doing this with SQL I would go with (Select SUM(hours) where
categor...