T
tim
Hello all,
I cannot figure this out for the life of me. I looked over the boards,
but didn't find anything that would help. Also, I am just learning
Access, so please respond with idiot proof directions, and thank you in
advance.
I have a single table that my user's enter data into. The table has 4
fields that I use to query data by (Date, Shift, Right Side/Left Side,
Front/Rear), and 50 or so fields that store values equal to errors
found in our product. Every day the quality folks keep up with errors
that occur, and then enter the data into the database. All of the
errors have default values of 0. The operator opens a new record,
inputs the Date, Shift, etc. and then changes the 0's of the fields
that had errors during the day to an integer equaling the number of
errors at that point.
I hope this is clear.
Anyway, I want to be able to query the data to give me the top 5 errors
that occurred on a particular date, or shift, or date and shift, or
date, shift and right or left, etc. Basically, by any combination of
the 4 identifier fields. To keep it simple, I can keep these as
separate queries, but I can't figure out how to have it sum, say, all
of the errors for October, and then report back the top 5.
Thanks!
Tim
I cannot figure this out for the life of me. I looked over the boards,
but didn't find anything that would help. Also, I am just learning
Access, so please respond with idiot proof directions, and thank you in
advance.
I have a single table that my user's enter data into. The table has 4
fields that I use to query data by (Date, Shift, Right Side/Left Side,
Front/Rear), and 50 or so fields that store values equal to errors
found in our product. Every day the quality folks keep up with errors
that occur, and then enter the data into the database. All of the
errors have default values of 0. The operator opens a new record,
inputs the Date, Shift, etc. and then changes the 0's of the fields
that had errors during the day to an integer equaling the number of
errors at that point.
I hope this is clear.
Anyway, I want to be able to query the data to give me the top 5 errors
that occurred on a particular date, or shift, or date and shift, or
date, shift and right or left, etc. Basically, by any combination of
the 4 identifier fields. To keep it simple, I can keep these as
separate queries, but I can't figure out how to have it sum, say, all
of the errors for October, and then report back the top 5.
Thanks!
Tim