Hello,
I am in need of some major help. I have built a database to track what the quality of a particular part is and count it. Let me start over....
Business Rules:
1. OEN/PN is on multiple items.
2. Each screen item has a specific quality rating.
3. The rating system is based on the numbers 0-8 (0 = New, 8 = Failed).
I want to be able to generate a report that lists the OEM/PN and the number of those OEM/PN that have a rating. Refer to the table below:
OEM/PN 0 1 2 3
Part Number 5 15 7
Please help and let me know if you need more info
Joe
I am in need of some major help. I have built a database to track what the quality of a particular part is and count it. Let me start over....
Business Rules:
1. OEN/PN is on multiple items.
2. Each screen item has a specific quality rating.
3. The rating system is based on the numbers 0-8 (0 = New, 8 = Failed).
I want to be able to generate a report that lists the OEM/PN and the number of those OEM/PN that have a rating. Refer to the table below:
OEM/PN 0 1 2 3
Part Number 5 15 7
Please help and let me know if you need more info
Joe