Forum Discussion

WCrist's avatar
WCrist
Copper Contributor
Jun 06, 2022

How do I create cumulative input databases?

To begin with, I am a new Access user.  I was tasked to come up with an idea of how to capture various information for our pilots - some of which will need to be updated on a continual basis.

 

For example, I need to capture total flight hours accumulated.  I can create a table which shows a field for a user to input hours flown for that day, then link that field to another that shows total flight time accumulated.  My problem is that the pilot will likely fly again tomorrow - but how do I keep the previously calculated total flight time and allow for a new day's input?

 

--Will

 

P.S. having difficulty trying to post this.  I apologize in advance if there are duplicate posts.

3 Replies

    • WCrist's avatar
      WCrist
      Copper Contributor

      arnel_gp 

       

      Thank you for the help.  The attached .zip puts it more into perspective for me.  I think there's a bit more information than needed, but I can work off of it as a template and modify to fit my needs.

       

      Thank you, again, for your help!

       

      --Will

  • tsgiannis's avatar
    tsgiannis
    Iron Contributor
    You don't need to " then link that field to another"
    Just one table that holds Pilot, datetime-start,datetime-end...you sum the hours and you get the result.