I have a db that tracks a rental business.
I have a query that returns how many open rentals are out any any given day. I enter the DOY and the query returns all rentals that have a start date before the entered DOY and either do not have a returned date or have a returned date that is greater then the DOY I entered.
So if I enter the DOY of 6/1/2019 the query returns 100, this is how many open rentals I have out on that date.
I want a query that will allow me to enter a date range, let's say 6/1/2019 - 6/5/2019 and it will return the open rentals I have out on each day. Ideally it would look like this:
Date OpenRentals
6/1/2019 100
6/2/2019 102
6/3/2019 104
6/4/2019 102
6/5/2019 107