Friday inventory report

[Molly]

I need to get an inventory report that shows the weekly
ending inventory as of each friday in the year. Any
ideas?

 

[[MVP] S.Clark]

Create the report to show current inventory, and then run it on Friday?

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[John Spencer (MVP)]

Need more information on your table structures to give any kind of suggestion.

For instance, do you have dates on additions to stock and on sales(?) from
stock?