Hi Jonh,
I need your help if you don't mind please?? In below code How can I use Where CLause to extract "Info Required" only?
I've thought using WHERE ([2014 Jan Check])="Info Required" would work but because it's an AS in IF Statement I don't know how I should use it in WHERE Clause
SELECT [CR],
INV.SD,
INV.UD,
IIF(ISNULL(MAX([Jan-14])), IIF(#01/01/2014# BETWEEN DATEADD("m", -13, SinceDate) AND NZ(UntilDate, #01/01/2100#), "Info Required", " N/A"), MAX([Jan-14])) AS [2014 Jan Check],
IIF(ISNULL(MAX([Feb-14])), IIF(#02/01/2014# BETWEEN DATEADD("m", -13, SinceDate) AND NZ(UntilDate, #01/01/2100#), "Info Required", " N/A"), MAX([Feb-14])) AS [2014 Feb Check],
MAX([Jan-14]) AS [2014 JAN],
MAX([Feb-14]) AS [2014 FEB],
FROM
x
GROUP BY [CR], INV.SD, INV.UD;