Hoping someone can help me with this; I have a file which shows inventory levels submitted every Monday, along with sales between each week. I need to be able to create a query so that someone can enter a start and end date and they will be shown the difference between the opening and closing inventory for that period, along with the total sales for each week in that period.
I'm thinking it's probably fairly simple, but unfortunately so am I so I've not been able to work it out!
Any help much appreciated as I have a deadline of Wednesday for the report.
I'm thinking it's probably fairly simple, but unfortunately so am I so I've not been able to work it out!
Any help much appreciated as I have a deadline of Wednesday for the report.