Counting a date with various activities
I have a database that tracks aircraft usage. The aircraft can be used by different pilots on the same day and I need some way of being able to track the number of days the aircraft is used.
In the example the number of days (the number I am trying to capture) the aircraft was flown would be 2 (7 sorties over those 2 days).
I have two tables associated with this example - one captures the event (date, aircraft used, pilot at the time of the flight) and the other captures the details of the flight (departure location, beginning engine meter reading, arrival location and ending meter reading and total flight time).
In a report using list view I want to be able to count the number of days the aircraft was flown, I am not having any issues summarizing the aircraft hours or the number of flights over those days.