How to sum by each field and transpose (1 Viewer)

[btamsgn]

Dear Everyone,
I'd like query which value sum by each column with condition from table "Tnpl" based on form "Fbe"
Input/select value on form "Fbe" for example: NPl1+NPl2+Npl3=AE+BE+DS
=> Output query sum as follows:

Pls find the attachment for your ref.

 

[June7]

Consider:

Query1: CO_UNION
SELECT MaNPL, Co1 AS Data, "C1" AS Src FROM Tnpl
UNION SELECT MaNPL, Co2, "C2" FROM Tnpl
UNION SELECT MaNPL, Co3, "C3" FROM Tnpl
UNION SELECT MaNPL, Co4, "C5" FROM Tnpl
UNION SELECT MaNPL, Co5, "C5" FROM Tnpl;

Query2:
SELECT CO_UNION.Src, Sum(CO_UNION.Data) AS SumOfData, [Forms]![Fbe]![Combo1] AS NPL1, [Forms]![Fbe]![Combo2] AS NPL2, [Forms]![Fbe]![Combo3] AS NPL3
FROM CO_UNION
WHERE (((CO_UNION.MaNPL)=[Forms]![Fbe]![Combo1] Or (CO_UNION.MaNPL)=[Forms]![Fbe]![Combo2] Or (CO_UNION.MaNPL)=[Forms]![Fbe]![Combo3]))
GROUP BY CO_UNION.Src, [Forms]![Fbe]![Combo1], [Forms]![Fbe]![Combo2], [Forms]![Fbe]![Combo3];