Make our error logging Access database into multiuser access with user interface and reports. Programming in SQL is acceptable too.
The purpose of this application is to track the errors our people make with their time entries and then to create reports that show us their trens over time and error rate %. We would like to rune reports for single individuals and to run reports the show set of individuals compaird against each other.
add - search - edit main table records and ancillary lookup tables
by date range (By Year/Week # to year/week #)/ se - totaling cost and number of errors and provideing error rate average per week against the SRs completed per week table. the date of the errors entered will need to be converted to the corresponding year/week numbers for the reports.
Trend graph date/range se, totally cost and errors
Inital sample data base provied
Please make additional suggestions for improvements.
I wish to have this completed in 6 days.
Please contact me by email with any questions.