Use the CROSSTAB in another query.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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?
SELECT [Date], Short_Name, TypeA, TypeB, Nz(TypeA/TotalOfQuantity*100,0) AS Pct FROM queryname;
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.