K
kfutbol
I need to track the on time performance of a vendor and produce performacne
results from the data. Currently, the information is received from the
vendors in an excel format whicih I upload into a table. It includes
Company, Date, Reference#, Scheduled Time, Actual Time, and a Comments (at
fault, not at fault) section. I am having difficulty creating queries and/or
reports that mazimize the data and use. I need a quicker, more efficient
method of reporting than just excel spreadsheets. I need a report that shows
the following;
1. Overall on time percentage (less not at fault) for individual reference
numbers and the total
2. Reference Numbers that do not meet the time = +/- 15 minutes
3. Individual on time percentage of routes.
results from the data. Currently, the information is received from the
vendors in an excel format whicih I upload into a table. It includes
Company, Date, Reference#, Scheduled Time, Actual Time, and a Comments (at
fault, not at fault) section. I am having difficulty creating queries and/or
reports that mazimize the data and use. I need a quicker, more efficient
method of reporting than just excel spreadsheets. I need a report that shows
the following;
1. Overall on time percentage (less not at fault) for individual reference
numbers and the total
2. Reference Numbers that do not meet the time = +/- 15 minutes
3. Individual on time percentage of routes.