Access 2007: measuring between dates

[BoyDay]

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.

 

[Alansidman]

Here is a copy of a db, that I created a while ago that employs what you are looking for although it is for tracking gas mileage, it will use the same concept of period to period changes. Look at the design of query one.

Alan

 

[BoyDay]

Thanks a lot, I'll give this a try.

 

[BoyDay]

I couldn't work it out I'm afraid - I've never used forms before which isn't helping me and I don't use Access that frequently; most of the knowledge I have in it is using update queries based on my much better knowledge of the functions in Excel.

I've attached my database for you to see. What I need people to be able to do is select from a drop down list in a form (or choose "select all") the distributor name and the forecast level, and then select the opening and closing inventory dates. Then they will be shown:-

Opening inventory value
Sum of "sales in" during this time period
Sum of "sales out" during this time period
Calculated Closing Inventory Value (opening value + sales in - sales out)
Closing Inventory Value
Difference between Closing Inventory Value and Calculated Closing Inventory Value