Solved Display the corrct Heading in pivot Query

[Sepp1945]

I have a query which displays all sold products total correctly, but the heading is the product code NOT the product name

TRANSFORM Count(tblPayments.Product_ID) AS CountOfProduct_ID
SELECT "Total Count" AS Remarks
FROM tblScale INNER JOIN tblPayments ON (tblScale.AMOUNT = tblPayments.Product_Value) AND (tblScale.ID = tblPayments.Product_ID)
GROUP BY "Total Count", tblScale.SCALE
PIVOT tblPayments.Product_ID;

tblScale.SCALE is the product name
how can i fix it

 

[ebs17]

Is that what you mean?

TRANSFORM Count(tblPayments.Product_ID) AS CountOfProduct_ID
SELECT "Total Count" AS Remarks
FROM tblScale INNER JOIN tblPayments ON (tblScale.AMOUNT = tblPayments.Product_Value) AND (tblScale.ID = tblPayments.Product_ID)
GROUP BY "Total Count"
PIVOT tblScale.SCALE

 

[Sepp1945]

yes thank you very much