If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Import data, generate monthly report
I need some help from people more knowledgeable then I. I need some suggestions on how I can do this task.
Here it goes. I have a group of mobile users who generate daily stats. I need to have something in place which will allow the mobile users to enter their stats online, then send the information to their respective supervisor. Then on the supervisors end, I need the data sent from the mobile user to be imported into another database/worksheet or whatever, and calculate the numbers for each of their subordinates each month. Example: User A Has the following stats for Day 1 in the month: Community Contacts: 5 Dispatched Calls: 4 Assists: 7 Initials: 2 At the end of the day, User A will need to send this information to his/her supervisor (Supervisor B) Supervisor B will recieve this information somehow and place it into a worksheet for the month. Supervisor B will recieve this type of information for about 10 other Users, and will need to place these stats onto a worksheet for each user. Then supervisor B will send a report to command staff showing the months stats for all of his users. Ideally, and if its not to difficult, I would like to have this process automated to where the mobile users input there stats and the information is collected for the month automatically. Then the supervisor can individually select the users in his squad and generate a report for his squads stats each month. We currently do this on paper. The users will turn in a daily stat sheet to their supervisor and the supervisor enters the information on a spreadsheet each month. I've taken on the task of how to automate this whole process, but I don't know enough about excel or access to try and make it work. Hints will be greatly appreciated. I hope this makes sense. If not e-mail me and I will explain further! Thanks. |
Thread Tools | |
Display Modes | |
|
|