SOLUTION Move your sum field behind your name field. The aggregate is showing up in column 1 so is writing over the grouping, I always try to put some long non-Aggregate fields to make room for the grouping. -- Melinda Layten, Senior Consultant Benetta Perry APS