ontime /late report from audit latest date

[essaytee]

Ok, here it is:

SELECT Issues.ARNO, Issues.Dateclosed, IIf(IsNull([TargetDate-First]),[TargetDate],[TargetDate-First]) AS TargetDateToUse, IIf(IsNull([DateClosed]),DateDiff("d",Date(),[TargetDateToUse]),DateDiff("d",[Dateclosed],[TargetDateToUse])) AS [Days-Diff]
FROM Issues LEFT JOIN qry_01_FirstValue ON Issues.ARNO = qry_01_FirstValue.RecordID;

The above produces the following:

I've also uploaded the file.

 

[rainbows]

thank you to you all ,

eassytee

that's exactly what I wanted . I tried many ways to get that with everyones ideas , never in a month of sundays would I have got that


thanks again steve