Crosstab Query to show percentage of row total

[keith2511]

I have a crosstab query which sums the values of a type of product by date and location - table1.

How can I add another column to row the value of Type A as a percentage of the Total Of Quantity?





Thanks

[June7]

Use the CROSSTAB in another query.

[keith2511]

Thank you for replying but I would need more detail to understand your suggestion.

If the result of the query groups the same table field (name of type) by it's contents (Type_A, Type_B), how do I refer to only values of Type_A in the subsequent query?

[June7]

SELECT [Date], Short_Name, TypeA, TypeB, Nz(TypeA/TotalOfQuantity*100,0) AS Pct FROM queryname;