Okay, I feel like this should be terribly simple, but I can't seem to work it out.
I have a DB that tracks data in a patient survey by month. In other words, Patient ID, Patient Name, and then a series of questions about the effectiveness of their treatment, rated on a scale of 1-10. So the...