I'm trying to decide between Access and Excel on this one. I don't have any Access experience, but I'm having trouble building this in Excel.
Essentially, my department needs to track rejections.
This includes:
Rejection Number
Rejection Type/Description
Part Number
Lot ID
Engineering Disposition
Work Center/Area
Operator(s)
Machine Asset Number
The problem is that there multiple instances of more than one operator running a machine for a part that has a rejection, as we have two shifts and a weekend shift at our facility. When I attempted to build this in Excel originally and filter results with a pivot table, it would work but showed multiple rejections per machine (due to there being several operators running that machine). I've since tried separating the operators by shift, but that still won't work, owing to the fact that there can be different operators running that machine/job from day to day.
Is Access the right tool for this job, or will I run into the same issues when entering data.
Bookmarks