I'm trying to track items on rent each day. What I have is Item#, Start Date and End Date. I need to end up with a list of items and the days they are on rent. For Example:
Item 1 went out for rent on 3/1/2015. It was returned on 3/4/2015.
Item 2 went out for rent on 3/1/15. It was returned the same day, 3/1/2015.
I need to end up with a list that looks like this
Item 1, 3/1/15
Item 1, 3/2/15
Item 1, 3/3/15
Item 1, 3/4/15
Item 2, 3/1/15
I can use the DateDiff function + 1 to get the total number of days. I think I need a loop until function
If Start = End, append Item# and Start Date to a table
If Start<> End, for i through (DateDiff number)
Append Item# and Start +1
Do Until i= DateDiff number
I think I have the logic, I have no idea where to start with the script.
Also, I have mostly done VB in Excel. I don't know anything about whether or not I need DAO functions.
At some point down the road, I'm going to have to add rental time in hours to this but I want to understand how to do this in days first.