Query Problem

[BlueWater]

I have what seems like a simple query, but whatever I am doing does not work.
Problem: I have an owners table this is arranged vertically, but I want it horizontal. There are two conditions:
1-One owner having a percent value of 1 (100%)
2-Two owner each having a percent value of 0.5 (50%)
Using a new query I would like to add new field headings like Lastname1, Firstname1, Middle1, Suffix1, Percent1, Lastname2, Firstname2, Middle2, Suffix2, Percent2
Is this reasonable?
See attached file: Access2007QueryQuestion.doc

 

[Ziggy1]

doesn't sound like a good idea for a query, make a Report and set the page to 2 columns.

 

[BlueWater]

Ziggy1
Thanks for your help...