Inventory Days on Hand?

[unit213]

I have a program built in Excel that will calculate inventory days on hand (amongst other things).
A few members helped me out with the DOH formula in this thread:

http://www.mrexcel.com/forum/showthread.php?t=367612

I have all the necessary linked tables and queries in place. However, I need to duplicate this in Access.
Unfortunately I have never done something similar to this days on hand scenario in Access before.

Can anyone point me in the right direction?

Thanks in advance!

Dan

 

[xenou]

I'm afraid if your Access tables look like your Excel table its going to be rough...
What exactly is "all the tables" and "all the queries"?

 

[Will_B]

I've looked at your Excel thread and I think I understand the business question you are trying to answer. Correct me where I am wrong: Given a specific Finished Goods Inventory as of today (e.g., 80 units), how many days' worth of units on-hand do I have that total up to at least the FGInv value (e.g., 80)? Is this correct? If so, would you only ever do this calculation on today's date --- or might you want to specify a date in the past or future as your start date?

If I have understood you correctly, then we'll need to create a function using Visual Basic for Applications (VBA). It should be simple enough. You'll then be able to use that function in queries, forms, and reports as if it were an ordinary Excel formula. Let me know how well I've understood what you need.