@Marygolds3 I've often found that joins can result in duplicates when aggregated. Also, even though you are using MAX, the Sum of time.custcol1 will still be the sum of all records that match the criteria for the project, not just for the Name/Customer that shows up in max.