Kamlesh Jain
asked on
Query to summarise data Like Pivot Table
Hello,
i am trying to generate a List Data from a query with one field as "salable".
SELECT DISTINCT QryDistinctTEST.product, QryDistinctTEST.Storage_Po rt, QryDistinctTEST.Salable
FROM QryDistinctTEST
WHERE (((QryDistinctTEST.Salable )>0))
ORDER BY QryDistinctTEST.product;
Now i wish to generate a report with Total Salable Qty of each product, stored at each Port. In general terms, there are only 3/4 Storage Ports but product can be at any port.
Report shall be like :
Port1 Product 1 10 MT(Qty)
Product 2 20 Mt (Qty)
Port 2 Product 1 10 MT(Qty)
Product 2 20 Mt (Qty)
Grand Total
Hope i am able to explain my problem.
Thanks in advance.. !
Regards,
stock.png
i am trying to generate a List Data from a query with one field as "salable".
SELECT DISTINCT QryDistinctTEST.product, QryDistinctTEST.Storage_Po
FROM QryDistinctTEST
WHERE (((QryDistinctTEST.Salable
ORDER BY QryDistinctTEST.product;
Now i wish to generate a report with Total Salable Qty of each product, stored at each Port. In general terms, there are only 3/4 Storage Ports but product can be at any port.
Report shall be like :
Port1 Product 1 10 MT(Qty)
Product 2 20 Mt (Qty)
Port 2 Product 1 10 MT(Qty)
Product 2 20 Mt (Qty)
Grand Total
Hope i am able to explain my problem.
Thanks in advance.. !
Regards,
stock.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome. Happy New Year
ASKER