dimitrz
03-20-2010, 12:10 AM
Hi experts
Introduction
My team uses an Input tracker to track Helpdesk requests and Reception calls, everyone has their own tracker which gets updates every minute of so with new entries
All these input trackers are located in a common folder in common file server
On an average every person tracks close to 100 requests/calls in his tracker everyday
Requirement
Is it possible to capture data from all these trackers on a periodic basis (say at click of a button) so that it can be displayed in a consolidated format in MS Access ?
That way I can get a consolidated overview of all the requests and calls handled by all my technicians without having to go into each person’s tracker separately
I am afraid I am a total novice in MS access and have no clue on how to go about it
I have enclosed 2 samples 1) sample of the input tracker used by technicians 2) an sample example of how I need the data consolidated in MS Access
Any help would be much appreciated
Query cross posted at
http://www.accessforums.net/database-design/consolidation-db-4936.html#post17359 (http://www.accessforums.net/database-design/consolidation-db-4936.html#post17359)
Introduction
My team uses an Input tracker to track Helpdesk requests and Reception calls, everyone has their own tracker which gets updates every minute of so with new entries
All these input trackers are located in a common folder in common file server
On an average every person tracks close to 100 requests/calls in his tracker everyday
Requirement
Is it possible to capture data from all these trackers on a periodic basis (say at click of a button) so that it can be displayed in a consolidated format in MS Access ?
That way I can get a consolidated overview of all the requests and calls handled by all my technicians without having to go into each person’s tracker separately
I am afraid I am a total novice in MS access and have no clue on how to go about it
I have enclosed 2 samples 1) sample of the input tracker used by technicians 2) an sample example of how I need the data consolidated in MS Access
Any help would be much appreciated
Query cross posted at
http://www.accessforums.net/database-design/consolidation-db-4936.html#post17359 (http://www.accessforums.net/database-design/consolidation-db-4936.html#post17359)