Link to home
Start Free TrialLog in
Avatar of Kamlesh Jain
Kamlesh JainFlag for India

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_Port, 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
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kamlesh Jain

ASKER

Big thank you sir. Happy new year :)
You're welcome. Happy New Year