So this is something you (the collective "you") would manually enter into/delete from the table?
Yes....when we monitor the hours each customer logs onto the forklift we will deceide who must go onto the "watch list". It is not a table that will be used to capture data on a frequent basis. We will only make changes once a customer is recognised as a high operating hours customer.
OK, So the customers/clients notify you when each forklift reaches an additional 250 hrs operating time?
Do they report RTH at the end of the month? Daily? On a some schedule?
We contact each customer or visit each customer on a monthly basis and take the readings of the forklift hour metre. We then calculate the hours and can see which forklifts need to be serviced.
What this is leading to is "What is the report going to look like?". If the report is monthly and a customer doesn't report RTH for the month (things are slow), what then?
At the end of the month, we want to have a form where we enter:
1. Customer Name
2. The forklift number
3. The date range
and we want to see something like this:
CUSTOMER FORKLIFTNUMBER READINGDATE HOURS
Barnlab.......Forklift15...............01/09/2018...........1000...
........Forklift15...............03/10/2018............1130...130
........Forklift15...............31/10/2018............1299...169
........Forklift15...............30/11/2018............1420...121
I have a couple of other questions about the tables, but they can wait a while.
You should not apologize. And I would not say "incometance".......... how about "inexperience". We all have to start somewhere.
What I have learned is to start designing the tables/relationships on paper, whiteboard, the window, cardboard, even sticky notes.
Try and determine what data you will need for reports to ensure you capture all required data. Try and not store calculated data.
Once you have drawn the tables/relationships on the medium (ie Whiteboard, etc), try walking through the steps to enter data. Once that seems to be working ok, then get into Access.
Create the tables (Do not use Look up FIELDS, calculated FIELDS or multi-value FIELDS), form queries and forms.
Enter test data to make sure all works correctly and smoothly.
Then create the report queries and the reports.
So back to calculating run time hours. When you print a report, what will be the time frame?