I have a projected inventory table. The DateReqd field is the date I need parts fabricated. I need to fabricate enough parts to cover requirements until the The DateCover field (not to exceed this date). I want a SQL query that will report for each PARTNO, the date "A" and the quantity "B". PARTNO, PARTNAME, NEEDBYDATE, QUANTITY