Value list summary
I've been exploring this problem for several days and am admitting defeat. I have a test database that summarizes hours spent on design projects. My Details field has three items of a value list: Design, Production and Alterations. The Hours field beside it tracks hours on each task. I'm trying to create sub totals based on each item in the Details value list. The image shows my layout.
I see no reason why I can't do this but the solution eludes me.