Thanks X 1000.

I made a couple of changes to your solution and I got the results I am looking for.

SELECT

tlkp_Defects.Defect_Title,

count(*)

FROM

tbl_Assembly_Hold_Defects

join tlkp_Defects on tbl_Assembly_Hold_Defects.Defect_ID = tlkp_Defects.Defect_ID

join tbl_Assembly_Holds on tbl_Assembly_Holds.TagNumber = tbl_Assembly_Hold_Defects.TagNumber

WHERE

tbl_Assembly_Holds.Record_Date BETWEEN '8/12/2009' AND '8/14/2009'

GROUP BY

tlkp_Defects.Defect_Title