I’ve written a database with the assistance of Tek-Tips Forums programmer SCRIVERB, but have run into a new problem that I thought was working correctly. I’ve tried to reach SCRIVERB though his email shown in his profile, but it’s currently not active.
I need a report that tracks the number of jail inmates who are transported (trip) per day for the month.
I called it a “trip” because we are reimbursed for two officers assigned at a rate of $15.00 per hour for 1.25 hours of work and 44 miles at 36.5 cents per mile. That’s the average time and distance it takes us to transport an inmate from our jail to the federal courthouse or from there and back. Typically, we would leave the inmate with them for the day in the morning and pick the inmate back up in the afternoon. They will pay us for both the morning round trip (there and back) and then for the afternoon round trip (there and back again). Since each trip one-way takes 1.25 hours and is 44 miles long, one round trip (morning or afternoon) is 2.50 hours and 88 miles long or 5 hours and 176 miles for the whole day. But, there’s an additional problem. We may transport the inmate to the federal courthouse and may not bring him back (such as a sentencing where he’s taken directly to the Bureau of Prisons). In this case, we can only charge for the one-way trip.
I’m thinking, I need a report that will group by date for a given month (date parameter) all of the inmates who were transported, subtotaled for each day and totaled for the month. We can charge the government for each trip, but if the only trip for the day was a one-way trip, then that’s all we can charge for.
I need a report that tracks the number of jail inmates who are transported (trip) per day for the month.
I called it a “trip” because we are reimbursed for two officers assigned at a rate of $15.00 per hour for 1.25 hours of work and 44 miles at 36.5 cents per mile. That’s the average time and distance it takes us to transport an inmate from our jail to the federal courthouse or from there and back. Typically, we would leave the inmate with them for the day in the morning and pick the inmate back up in the afternoon. They will pay us for both the morning round trip (there and back) and then for the afternoon round trip (there and back again). Since each trip one-way takes 1.25 hours and is 44 miles long, one round trip (morning or afternoon) is 2.50 hours and 88 miles long or 5 hours and 176 miles for the whole day. But, there’s an additional problem. We may transport the inmate to the federal courthouse and may not bring him back (such as a sentencing where he’s taken directly to the Bureau of Prisons). In this case, we can only charge for the one-way trip.
I’m thinking, I need a report that will group by date for a given month (date parameter) all of the inmates who were transported, subtotaled for each day and totaled for the month. We can charge the government for each trip, but if the only trip for the day was a one-way trip, then that’s all we can charge for.
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
