A
Alberto
I have two queries.
One query (qryInventory) pulls the current inventory levels [current], min
inventory levels [min], and optimal inventory [opt] for a given product model
[product_model].
The other query pulls the each transaction for each product model over the
last 14 weeks. I am then utilizing a CrosstabQuery (qryProductSales) to show
the quantity of product models sold each week.
My problem comes when I want to combine these two queries. The way I have
attempted to do it is to create a report based on qryInventory and create a
subreport based on qryProductSales and join then by product_model.
The only query that takes a long time is the qryProduct Sales. It takes
about 20 seconds. All the other queries and reports/subreports, when run
individually take a matter of seconds, but for some reason when I run the
report and subreport together in the fashion described above, it takes an
extremely long time (so long that I have not been able to wait it out...30+
minutes).
Also, I should note that my column headings are static dates (i.e. week 1,
week 2, etc.) so I don't think that this is the problem.
Please help.
One query (qryInventory) pulls the current inventory levels [current], min
inventory levels [min], and optimal inventory [opt] for a given product model
[product_model].
The other query pulls the each transaction for each product model over the
last 14 weeks. I am then utilizing a CrosstabQuery (qryProductSales) to show
the quantity of product models sold each week.
My problem comes when I want to combine these two queries. The way I have
attempted to do it is to create a report based on qryInventory and create a
subreport based on qryProductSales and join then by product_model.
The only query that takes a long time is the qryProduct Sales. It takes
about 20 seconds. All the other queries and reports/subreports, when run
individually take a matter of seconds, but for some reason when I run the
report and subreport together in the fashion described above, it takes an
extremely long time (so long that I have not been able to wait it out...30+
minutes).
Also, I should note that my column headings are static dates (i.e. week 1,
week 2, etc.) so I don't think that this is the problem.
Please help.