Hi
I am relatively new to the coding world, I have created a few programs in access for my current company and thus far everything has been working fine. I recently stumbled onto a issue which I have not been able to find an answer to even with scouring pages, this is my first time posting any question on any forum.
I have a stock management database set up.
The idea is very easy in that the stock data is logged into one table and the changes to the quantity are logged into a different table along with the dates of the changes.
Now I need to set up a report to get the correct data onto a summarized report that is based on dates.
I previously set up a report that generates all movement items between 2 dates, groups them by stock code and sorts the dates from oldest to newest, this however generates a 62 page report due to the amount of movements per stock code.
The only thing the report requires is the following: Stock code, "last stock quantity by date", price, description, supplier.
My issue is getting the "last stock quantity by date field" to work.
i.e. if you enter the 31/09/2017 as the date it should give you the last movement balance for that item on or before the date specified.
Please help, I am at a dead end as to how to do this.
I am sure I can somehow figure this out but my time on this project is running out.