1 2 3 4 5
| TRANSFORM First(rqt_display_declaration_material_substance.Value) AS PremierDeValue
SELECT rqt_display_declaration_material_substance.DateDeclaration, rqt_display_declaration_material_substance.Type, rqt_display_declaration_material_substance.NameProject, First(rqt_display_declaration_material_substance.Value) AS [Total de Value]
FROM rqt_display_declaration_material_substance
GROUP BY rqt_display_declaration_material_substance.DateDeclaration, rqt_display_declaration_material_substance.Type, rqt_display_declaration_material_substance.NameProject
PIVOT rqt_display_declaration_material_substance.NameSubstance; |
Partager