Okay, so I have included the project in a download link because it's far easier to show someone what I am talking about rather than tell them. In short, I have an aircraft flight log that incrementally logs each aircraft flight hour and flight cycle. This is summed using the aggregate Sum() in a calculated unbound txtbox. In the project you will see a 'Tracking Module' form. This has a main form that creates a 'tracking template' which stores the lifespan records (denoted as TBO_Days, TBO_Hours, TBO_Cycles; TBO: Time Before Overhaul). Selecting the 'TempName' will bring up the associated sub-form record. This record is the specific part (if the part has consumption already when installed on aircraft, date installed on aircraft, aircraft installed to, and time/cycles on aircraft at install of part). All these variables should allow me to create a formula to calculate the 'remaining life' of the part. This is tricky for me, because I am obviously new to Access. Also, it isn't as simple because of the way flight records are updated: incrementally. So, if a propeller is installed on 'plane A' on 1/15/12 where the aircraft time at install was 1,200 hours and the propeller already had 200 hours of life consumed with a total life of 500 hours, then the question becomes how can I create a formula that will sum the incremental tally records of that specific aircraft to start 'counting down' from the remaining 300 hours of life on the part? (500 hrs total - 200 hrs already consumed= 300 hrs remaining). I am at my wits end with this; more of a writer really. So, any math types please help out! Below is the link of the project, so you can see just exactly what I am working with. And thank you for anyone who takes a stab at this, this is the final part of this project and becoming the most difficult for me!
Access 2007 Report Calculation Formula Question
- Thread starter PhilG
- Start date
