Travel days in a 365 day period

[CptZ]

I am in a military unit that travels about 10 days a month. I am trying to create a form that you can enter multiple date ranges and then quary in a given 365 day period how many days were spent traveling. Not sure if I need to use a formula or VB. Any suggestions pointing me in the right direction would be great. Thank you.

[shah1419]

please find the attached database example for your review.

[davegri]

CptZ_travels.zip
Here's a start that addresses your post directly.
It includes a table for trips, a table for personnel and a linking table between them in a many-to-many fashion.
The personnel info will allow you to create reports as to who took which trips if that's necessary.
Four forms allow data input to the tables, plus a Main form.
A totals query adds up the trip days for trips between two dates you specify. The query is run from a button on the trip assign form.