Sedang Disiapkan

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

Kemahiran: Visual Basic, Destop Windows

Lihat lebih lanjut: sigma aldrich, distribution defect, defect database, sample received form, picking packing, picking and packing, picker packer, packing logo, packing company logo, month year picker, distribution international, create my logo on line, create logo with windows, create a company logo on line, defect distribution xls, distribution report access vba, report distribution sample, objective c windows, objective c on windows, upload database, shipment , receipt, picking, picker, packing

Tentang Majikan:
( 0 ulasan ) St. Louis, United States

ID Projek: #99195

Dianugerahkan kepada:

rjmijares

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

$100 USD dalam 2 hari
(4 Ulasan)
3.5

8 freelancers are bidding on average $121 for this job

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). Lagi

$100 USD dalam 3 hari
(3 Ulasan)
3.8
sourcecoder

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

$100 USD dalam sehari
(6 Ulasan)
3.6
Naagarajan

I am having 5 years exp in Access and VB

$100 USD dalam 5 hari
(0 Ulasan)
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

$120 USD dalam 10 hari
(0 Ulasan)
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.

$200 USD dalam 10 hari
(0 Ulasan)
0.0
leopro

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

$100 USD dalam 7 hari
(0 Ulasan)
0.0
josecortes

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

$150 USD dalam 5 hari
(0 Ulasan)
0.0