Devam Ediyor

Distribution Defect Database

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

Beceriler: Visual Basic, Windows Masaüstü

Daha fazlasını görün: sigma aldrich, distribution defect, defect database, sample received form, picking packing, picker packer, packing logo, packing company logo, month year picker, distribution international, create logo windows, create company logo line, defect distribution xls, distribution report access vba, report distribution sample, upload database, shipment , receipt, picking, picker, packing , packed, insert date, determine, date picker

İşveren Hakkında:
( 0 değerlendirme ) St. Louis, United States

Proje NO: #99195

Seçilen:

rjmijares

Hi, please see PMB for details of my bid. Thank you

2 gün içinde 100$ USD
(4 Değerlendirme)
3.5

8 freelancer bu iş için ortalamada 121$ teklif veriyor

Kingpin1962

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). Daha fazlası

in 3 gün içinde100$ USD
(3 Değerlendirme)
3.8
sourcecoder

I'm an expert of access, vb, and office. will do it in no time. regards, Raphael.

1 gün içinde 100$ USD
(6 Değerlendirme)
3.6
Naagarajan

I am having 5 years exp in Access and VB

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0
infoims

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

in 10 gün içinde120$ USD
(0 Değerlendirme)
3.2
mikeflath

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.

in 10 gün içinde200$ USD
(0 Değerlendirme)
0.0
leopro

I have done many projects with intricate reports. Would like to work on your project. Regards

in 7 gün içinde100$ USD
(0 Değerlendirme)
0.0
josecortes

I can help you with your project. I speak german too and i am a Access Basic developper.

in 5 gün içinde150$ USD
(0 Değerlendirme)
0.0