illusionek
Registered User.
- Local time
- Yesterday, 19:59
- Joined
- Dec 31, 2013
- Messages
- 92
Hello
I got this query with a subquery and it takes couple seconds to run.
However if I try to go to the last record, export it to Excel via ExternalData tab or Make Table, my Access stops working and then I get an error message there is not enough memory.
I am getting lost here as in the end I need to link Excel to this query.
Any idea why it happens?
I got this query with a subquery and it takes couple seconds to run.
However if I try to go to the last record, export it to Excel via ExternalData tab or Make Table, my Access stops working and then I get an error message there is not enough memory.
I am getting lost here as in the end I need to link Excel to this query.
Any idea why it happens?
Code:
SELECT qryCalculations.[Item Number], qryCalculations.[Week Commencing], qryCalculations.ClosingInventory, (Select qry2.ClosingInventory from qryCalculations as qry2 where qry2.[Item Number] = qryCalculations.[Item Number] and qry2.[Week Commencing] = qryCalculations.[Week Commencing] - 7) AS PreviousClosingInventory
FROM qryCalculations;