Greetings
I'm using Access 2016. I have a report (not using any VB, just building a report) in which I would like to display an individual's name along with all of that individual's qualifications (always at least one, and typically no more than three). The qualifications are stored in a multivalued field. I am trying to use a Combo-box in the report, but my resulting report displays the individual twice if they have two qualifications, thrice if they have three, etc. It looks something like below:
Joe Smith
MD
Mary Jones
MD
Mary Jones
PhD
I'd like it to be:
Joe Smith
MD
Mary Jones
MD, PhD
Any suggestions?
I'm using Access 2016. I have a report (not using any VB, just building a report) in which I would like to display an individual's name along with all of that individual's qualifications (always at least one, and typically no more than three). The qualifications are stored in a multivalued field. I am trying to use a Combo-box in the report, but my resulting report displays the individual twice if they have two qualifications, thrice if they have three, etc. It looks something like below:
Joe Smith
MD
Mary Jones
MD
Mary Jones
PhD
I'd like it to be:
Joe Smith
MD
Mary Jones
MD, PhD
Any suggestions?