Search results

Attach, image for example. code: SELECT [00].CPF, Sum([62].CH) AS SomaDeCH, First([62].[Disciplina]) & IIf(Count([62].[Disciplina])>1,"," & Last([62].[Disciplina])) AS Materias FROM Sheet1 AS 00 INNER JOIN [GPE62_2014-08-12] AS 62 ON ([00].MATR = [62].CodigoSEAP) AND ([00].VINC =...

Other example: SELECT [99].Ano, First([99].[GRUPO]) & IIf(Count([99].[GRUPO])>1,"," & Last([99].[GRUPO])) AS Materias FROM 99 GROUP BY [99].Ano;

Ola amigos (Hello friend) abaixo uma consulta que funciona. (Above this query run good). Concatena por linha (concatenate line). A consulta é simples de escrever (this query is very easy for white and undestand) SELECT [00].CPF, [62].Habilitacao, Sum([62].CH) AS SomaDeCH...