Hello,

I have a table or query result set [TeamSupporter] which shows like TeamSupporter.JPG below.
TeamSupporter.JPG
However, I would like to show like the following view, so that for each district, the supporters' names will reach to the topmost of the column within the same FormDistrict like TeamSupporterNewView.JPG below.
TeamSupporterNewView.JPG

What I should do as I am using access2010? I haven't work with SQL or VBA for a long time so I am not sure whether it is possible to show. Thanks in advance for your help.