Hi guys,
I have an Inspection form in which operators enter the Part Number, the quantity in (before inspection) and the quantity out after inspection.
from this form, i created a report that shows the Yields by part number and by shift.
ex.
Day shift
"part number 1" qtyin: 1000 QtyOut: 750
"part number 2" qtyin: 2300 QtyOut: 200
etc.
etc.
Night shift
"part number 2" qtyin: 1000 QtyOut: 750
"part number 4" qtyin: 2300 QtyOut: 200
etc.
etc.
the problem is that certain part numbers belong to one category-Chips
and the others to the category- Diodes.
the report mixes the part numbers together presents them alphabetically.
ideally, I would want it to show as:
Day Shift:
chips:
part number whatever
part number whatever
Diodes:
part number whatever
part number whatever
and similarly for nights.
what is the best way to separate the these part numbers depending on the category they belong to because the information for the report is all in one database?
any suggestions would help.
thanks.