At the moment my co uses a spreadsheet to note how many orders each
engineer is assigned and this is updated manually. I've thought about
transferring this to Access and have thought of two possible ways, 1 is
clearly better then the other but goes beyond my Access knowledge.
If anyone cares to have a read I'd appreciate any feedback.
Each particular order may have a number of sites and this is also
noted. The orders allocated per engineer is simply allocated as they
come in
Method 1
--------------
Create a form in which all the relevant details for each order (ie
engineer, number of sites) are inserted and this acts as a new record
for each order. Stats can then be extracted using a number of reports
and queries. This is a very simple approach but having a record for
each order is quite unnecessary as we only need a count of how many
orders and sites an engineer is working on.
Method 2
---------------
Enter the details in a form and on the click of a button, the values
entered on the form will be added to a table setup with the engineers
for each day. This way there will only be a max of 28 records per day
as we have 28 engineers.
Woulkd anyone have an idea of how to use numerical values entered into
a form to update a main table by simply adding the figures?
I hope this all makes sense.
Thanks