Stock Summary Query of Warehouses

[ahmad_rmh]

I want to make stock summary query as per the attached sample jpg.file.

The stock summary should have to show crosstab query as per the table entities.

I have also attached the database. Kindly suggest. thanks

 

[Pat Hartman]

The cross tab query will generate the detail lines. You need to bind it to a report to do the grouping and totalling.

 

[ahmad_rmh]

The main warehouse summary is not showing in the crosstab query.

1st want to show a complete picture of store including the main warehouses.

 

[Pat Hartman]

There is no way to debug this without seeing code and data. There is either a query issue or a data issue to explain why the data is not showing. Regarding the second question, what have you tried so far? People who help you here do it because they like to help. If you need custom work done, several members are willing to take paid work.

Please upload the database and tell us how to open the query in question so we don't have to muddle through bunches of objects.