Distribution Defect Database
$100-300 USD
Paid on delivery
Overview: I have created a very rudimentary Access Database which allows me to track the errors made by packers and pickers in my distribution center. I upload an excel file sent to me by our German subsidiary which lists all the errors and the type of error. This file contains Product number, Batch number, shipment number, type of error, date of receipt and quantity received. I then match this file based on product #, batch # and Shipment # to another file which includes all shipments sent out and who picked and packed the product for that shipment. I do this match up on a monthly basis and then run a query to determine the number of errors made by picker and packer and the number of lines shipped by picker and packer. I can then calculate the % errors. This information is then distributed to the employees and the supervisors.
Objective: To take this information and create a summary report for supervisors and detailed reports for the pickers and packers.
Detail: I would like four report created. The report name and the query which should provide you with most of the data is listed below.
1. International Errors Packing Summary - Q24 Packing Errors per Line
2. International Errors Picking Summary - Q34 Picking Erroes per Line
3. Packer Detail Report - Q25 Packing Errors Detail
4. Picker Detail Report - Q35 Picking Errors Detail
Attached is an excel file: "Report Samples.xls" which has a sample of each report.
Attached is a JPG of the company logo please insert this in the upper left hand corner. Sigma-Aldrich [url removed, login to view]
I would like a form created to drive the reports. I would like access all the reports from the same form. For each report I would like to be able to select the month and year I would like the report run for. For reports 3 and 4 I would also like to select from a drop down who to run the report on. I realize that this will require a change to the querys.
Unfortunately I was not able to attach the database
Project ID: #99195
About the project
Awarded to:
8 freelancers are bidding on average $121 for this job
Dear Buyer, I work with MS Access databases and Visual basic for the last seven years. What you ask can be done easily, either internally in Access or with small separate VB program using Crystal Reports (suggested). More
hi, we have a good team of VB and VB.NET developers with experience in ERP, Hotel Management and Inventory Management Softwares. Pls contact with your yahoo id so we can get this started...best regards..manish
I can do this work for you perfectly well on Delphi. I have the great experience on working with Access and Excel, and creating different kind of database reports. So, we can talk over details.
I have done many projects with intricate reports. Would like to work on your project. Regards