« First « Previous Comments 70 - 74 of 74 Search these comments
To HeadSet
@HeadSet - you still need my solution, or have you got a solution?
I am currently actively using TPB' s SQL solution, and it works great. I am also looking over what Blue produced. Therefore I no longer need a solution, but I appreciate that you would have put forth the effort.
It was limited to working on 1 year at a time.
Fun side project. Just wanted to make certain you were set, because it's not much work to complete it - but it's work to use it.
« First « Previous Comments 70 - 74 of 74 Search these comments
I cannot figure this out in Access tools/VBA or Excel tools/VBA. I really just need to know how many days each cab was leased out for the month, and I think this grid is the way to do it. For example, a cab that was leased out from 1-8 Nov and then from 8-15 Nov was leased for 15 days. Output is any way to show Cab 1 for 24 days, Cab 3 for 30 days, Cab 6 at 4 days, and so on. I do not want to double count dates that overlap.
Any ideas, to at least point me at what logic to use? Does not have to be Access or Excel.