Beste allemaal,
Ik heb onderstaande query en wil graag in kolom "LCP" de achtergrond een kleur geven als er iets in staat. Is dit mogelijk en zo ja, hoe?
groet, Patric
Ik heb onderstaande query en wil graag in kolom "LCP" de achtergrond een kleur geven als er iets in staat. Is dit mogelijk en zo ja, hoe?
Code:
SELECT [Check invoice].[Shipment date], [Check invoice].Coatlijn, Sum([Check invoice].[lengte rol]) AS [Totale lengte], Sum([Check invoice].[netto m2]) AS [Totaal m2], [Check invoice].Invoice, [Check invoice].Lotnummer, [Check invoice].Specificatie, [Check invoice].[S/P], Count([Check invoice].Lotnummer) AS [Aantal colli], [Check invoice].Produktbreedte, [Check invoice].[PO PLC], [Check invoice].[Short spec], [Check invoice].[Adhesive breedte], [Check invoice].[TAC breedte], [Check invoice].[AV TAC], [Check invoice].[AV adhesive], [Check invoice].[Prijs (€/m2)], [Check invoice].LCP
FROM [Check invoice]
GROUP BY [Check invoice].[Shipment date], [Check invoice].Coatlijn, [Check invoice].Invoice, [Check invoice].Lotnummer, [Check invoice].Specificatie, [Check invoice].[S/P], [Check invoice].Produktbreedte, [Check invoice].[PO PLC], [Check invoice].[Short spec], [Check invoice].[Adhesive breedte], [Check invoice].[TAC breedte], [Check invoice].[AV TAC], [Check invoice].[AV adhesive], [Check invoice].[Prijs (€/m2)], [Check invoice].LCP;
groet, Patric