AnsweredAssumed Answered

Counting a date with various activities

Question asked by axl on Feb 25, 2014
Latest reply on Feb 27, 2014 by philmodjunk

Title

Counting a date with various activities

Post

     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.

     Example:

     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).

     Any suggestions?

     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.

      

      

Outcomes