I have an inventory which I bill various users for storage on (each item is a separate line item). I record the day storage began as one field and the date storage is closed as another.
I need a report to generate the number of billable days each month for storage for each item in inventory. So, I need to have access look at each "began date" and generate the number of days in each month storage took place til the "close date".
Is this possible? I am flexible on how to get this information. I am an ACCESS NOVICE!
Thanks in advance.