Forum Discussion
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
- arnel_gpSteel Contributor
you can use the Technique here.
you need master table for pilots and also table for the airports.
add another table to records the flight.
- tsgiannisIron ContributorYou 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.