raziel3
Registered User.
- Local time
- Today, 00:32
- Joined
- Oct 5, 2017
- Messages
- 275
I'm trying to make a Opening/Closing stock query. So far I've managed to do it for 2022 but how would I go about using 2022 Closing Stock as 2023 Opening Stock?
I've attached the db and the query "RMMOVEMENT" is my current progress.
Side note:
I've heard that keeping a table (rather than having a query) with the closing stock figures is best practice. What do you all think?
I've attached the db and the query "RMMOVEMENT" is my current progress.
Side note:
I've heard that keeping a table (rather than having a query) with the closing stock figures is best practice. What do you all think?