This sounds good if you want standardized prioritization. I had understanding you wanted users to assign priority on case-by-case basis, using their judgment. Ideally, those judgments would be saved into a dependent table as part of data entry process so that report could be recreated on demand.
June,
Sorry for the late reply as I took a much needed break from Access over the holidays.
Looking back, you are correct in stating that I'd like to have the users assign a priority on a case-by-case basis. My apologies.
I'm still struggling with how to get the claims to print in the priority order that the user sets. All that the temp table contains is the 'Defect', the total number of each 'Defect' and the Priority Ranking. Now, each separate 'Defect' has a Claim associated w/ it. The details within the Claim are what needs populated into the report in the order set by the user. After the priorities are set, I'm not sure how to go about breaking out each 'Defect' so that it's pulling in the correct claim info into the report and ordering it correctly.
Halfway there! If anyone has any ideas///I'm all ears!
Happy 2020 to all!