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 Work Management Improvement CapabilitySource Phone: (484) 505-6855 site:
www.capabilitysource.com email: melinda.layten@capabilitysource.com - we simplify your work so you can run your business -