I m trying to calculate how much one of our members get for leave when their on orders. If they have orders that start from 1st-6th they get 2.5 days, 7th-12th 2 days, 13th-18th 1.5 days, 19th-24th 1 day, and the rest of the month .5. Then 2.5 for each month on the orders after the first month. And on the back end its reversed going down.
I m trying to have the access database give the leave for the date the order started on. Then give me the months and 2.5 for each one then add them up and give me the leave amount for that day i.e 2.5, 1.5 etc
Like if the orders start on 6OCT15 and end on 16May16. I want it to give me 2.5 for the 6th then give me the Months Nov, Dec, Jan, Feb, Mar, and April at 2.5 for those months. If there return date is May 10 and I add a day for travel.
Basic formula is
11MAY16(return date) + 2.5+2.5+2.5+2.5+2.5+2.5=17.50 days (MAY 29, 2016) and because it s the 29th the get another 2.5 days.
Any help on this would be great if this doesn t make any since please let me know.

TSgt Olivera