Distribution Defect Database

Completed Posted Oct 19, 2006 Paid on delivery
Completed 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

Visual Basic Windows Desktop

Project ID: #99195

About the project

8 proposals Remote project Active Oct 20, 2006

Awarded to:

rjmijares

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

$100 USD in 2 days
(4 Reviews)
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). More

$100 USD in 3 days
(3 Reviews)
3.8
sourcecoder

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

$100 USD in 1 day
(6 Reviews)
3.6
Naagarajan

I am having 5 years exp in Access and VB

$100 USD in 5 days
(0 Reviews)
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 in 10 days
(0 Reviews)
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 in 10 days
(0 Reviews)
0.0
leopro

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

$100 USD in 7 days
(0 Reviews)
0.0
josecortes

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

$150 USD in 5 days
(0 Reviews)
0.0