Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: Pilot Semi-annual tracking SQL

    Using MS Access 2007
    I track flight time for Aviators, who have minimums to maintain based on their birthmonth. I am looking to automatically calculate on a report/query the ammount of time that they have flown within a 6 month timeframe based on their b-month, and the current date. Six months after Birthmonth and 6 Months Prior to Birthmonth. For example Aug is my birthmonth and it is Currently Feb. I would only want to calculate the data between 31 Aug and 1 Mar because todays date of 25 Feb falls between that range. And if todays date were 3 Mar it would calculate the data between 28 Feb and 1 Sep.

    I have two tables and I will put sample data in order to get better help.
    1. “Flight Input”
    Lname Flt_Date ACFT_MDS FS_ID HRS
    Joel 8/4/08 2B-24 W 2.0
    Billy 8/4/08 UH-1 H 2.5
    Mike 10/24/08 UH-1 D 3.0
    John 12/9/08 UH-1 N 2.0
    Billy 12/10/08 2B-24 W 1.5
    Joel 12/17/08 UH-1 NG 3.5
    Chris 1/08/09 UH-1 H 1.0
    Mike 2/13/09 UH-1 D 2.5

    AND table 2 “PILOTS”

    LNAME BIRTHMON
    Joel 5
    Billy 12
    Mike 1
    John 11
    Chris 8

    The end result would look like this.

    Lname Birthmon SumOf2B-24 SumOfD SumOfN SumOfNG SumOfW SumOf H
    Billy 12 0 0 0 0 0 0
    Chris 8 0 0 0 0 0 1.0
    Joel 5 0 0 0 3.5 0 0
    John 11 0 0 2.0 0 0 0
    Mike 1 0 2.5 0 0 0 0

    Thank you.

  2. #2
    Join Date
    Feb 2009
    Posts
    2
    Darn, That did'nt turn out good.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •