Hi,
Is what I want to do possible? I haven't found a solution. I mainly use just Access. I'm not good a VBA.
I have a table that has a Date field and a field called "InOut".
Example
2015-10-14 In
2016-01-01 Out
2016-02-01 In
2016-03-15 Out
2016-04-20 In
The dates are random, not at the beginning or end of a month.
In this example the item was "In":
Between 14-Oct-15 and 01-Jan-16
Then again between 01-Feb-16 and 15-Mar-16
And from 20-Apr-16 until Now()
Is there a way calculate the total "In" days in a query or series of queries?