How to consolidate and return extensions

[gmaxey]

I understand. Not fully, but well enough. Thank you so much. My next objective was to filter the value returned on a specific extension type. I knuckled that part out myself:

SELECT tblProjects.pkProjID, tblProjects.Base_Due_Date, Sum(Nz(tblExtensions.NumDays)) AS Total_Days_Extended
FROM tblProjects LEFT JOIN tblExtensions ON tblProjects.pkProjID = tblExtensions.fkProjID
WHERE (((tblExtensions.ExtType)="A"))
GROUP BY tblProjects.pkProjID, tblProjects.Base_Due_Date