Recent content by eczlk91

  1. E

    SQL Problem

    I didn't think i would stir up so much controversy. I truly appreciate all the input and it has given me a good chance to see all sides of the issue. I still do have one question though: In a form what is the best way, using a combo box, to select specific data from two different table...
  2. E

    SQL Problem

    I will give it a shot, thank you for your time
  3. E

    SQL Problem

    I have been working on this for three days, looking on the web and even downloading tutorials, Please help!!! I am trying to get specific date from my tables: TBL-AirportInfo TBL-AirportAssessment I am developing a threat assesments of airports where I assign 10 different factors to an...
  4. E

    Access 2007 Advice please

    yes, RGM is the sector D is the mode of flight FW is type of aircraft the boxes with numbers are the flight hours flown in the sectors In one flight I have tried to group the following information on one form: AOR Number Crew: PIC SIC Aircraft Type: Agency Supported: Up to 6...
  5. E

    Access 2007 Advice please

    I have attached what I have so far? I have also attached the excel sheet I am trying to replace Thank you for your help,
  6. E

    Access 2007 Advice please

    I am trying to account for flight time in a specific condition (Day, Night, NVG) in a specific Zone (ABC,DCG,CBG) for a specific amount of time (1.2, 2.3, 2.4) in one aircraft (FW, RW). An example would be flew the fixed wind in sector (abc) day time for 1.0 hours Sector (DCG) night time .5...
  7. E

    Access 2007 Advice please

    All, I am trying to figure out how to do the following Flight mode Zone HGR FFR FUL HUG JYT Day 1.2 3.4 Night NVG 1.3 The following is the data for this piece of data: Type of aircraft: C-206;Bell 607;uh-1 Flight Mode: day;night;NVG Zones...
Top Bottom