Torna al Thread

SELECT PS13.DCAP, PS13.AUSSL, PS13.C3, PS13.C4 FROM PS13 WHERE ((PS13.DCAP Between #9/15/2014# And #9/15/2015#) AND (PS13.AUSSL="AUSSL 10")) UNION ALL SELECT DISTINCT IIf((DCount("*","Q1","((PS13.DCAP Between #9/15/2014# And #9/15/2015#) AND (PS13.AUSSL='AUSSL 10'))"))=0,0) AS DCAP, 0 AS AUSSL, 0 AS C3, 0 AS C4 FROM PS13 WHERE ((IIf((DCount("*","Q1","((PS13.DCAP Between #9/15/2014# And #9/15/2015#) AND (PS13.AUSSL='AUSSL 10'))"))=0,0)) Is Not Null) ;
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5