essaytee
Need a good one-liner.
- Local time
- Today, 21:46
- Joined
- Oct 20, 2008
- Messages
- 512
Ok, here it is:
The above produces the following:
I've also uploaded the file.
Code:
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.