Bruce, thank you so much for your help. Your form worked great.I've updated the rep subform to include all the other columns going by your example, but for some reason, in MY form, my repTotals subform only calculates for the first client selected in the list. For example, in my form, if you select ...