Hello Friends,I am new here and also to SQL Server. I am making an Access frontend and SQL Server backend application. Almost everything is now working except this query which I tried to convert to SQL Server syntax but without any success. Hope you people will show me how it really works. ThanksTRANSFORM First([Messung_Ottensen].[CSB])AS [SummeVonMessung_Ottensen_NO2_N Nitritstickstoff]SELECT (Format([Dat],"dd mmm yyyy"))AS Ausdr1 FROM Messung1WHERE (((Messung1.Dat)>#9/1/2003#) AND ((Messung1.Messung_Ottensen.Projekt)="ottensen")AND ((Messung1.Hangwasseranalyse)<>-1))GROUP BY (Year([Dat])*12+Month([Dat])-1),Messung1.Dat, (Format([Dat],"dd mmm yyyy")), Messung1.Hangwasseranalyse PIVOT Messung1.Messung_Ottensen.Projekt;
Access crosstab query conversion
Posted - 2005-10-27 : 14:01:45
