After submitting the query
TRANSFORM Count(LINEA) AS [El_Valor] SELECT LINEA, Count([COCHE01])+Count([COCHE02])+Count([COCHE03])+Count([COCHE04]) AS Total FROM [02/03/2021] WHERE (((LINEA) Not Like 'N*') AND ((ID_LINEA)<=2000)) GROUP BY LINEA, ID_LINEA ORDER BY LINEA PIVOT LINEA
which in Access 97 works, returns
java.sql.SQLException: Syntax error: Stopped parse at TRANSFORM(id133)
Could you help me
|
Your query is not SQL syntax. You can find Pivot sample at here
But I don't think you're using PIOVT syntax. Maybe you want
SELECT Count(LINEA) as [El_Valor] ,Count([COCHE01])+Count([COCHE02])+Count([COCHE03])+Count([COCHE04]) AS Total FROM [02/03/2021] WHERE (((LINEA) Not Like 'N*') AND ((ID_LINEA)<=2000)) GROUP BY LINEA, ID_LINEA ORDER BY LINEA
|
Main
webmaster@hxtt.com