aligning detail in reports from a query (1 Viewer)

[lmpassaglia]

hi i am a new user. i am trying to create a report to look a certain way, with no luck. I have created a table with a list of players in one field [lastname], and another field has the [position].

smith pitcher
jones catcher
hall 1stbase

next i ran query, to seperate out each position into its own field. I added an expression for each position: iif([position]=pitcher,[lastname],""), etc... creating a seperate field for each position, which is correct in datasheet view.

next i created a report from the query with the column headers labeled by Positon, i.e. Pitcher catcher 1st base. however when the detail section populates, there are gaps in each column. how can i move each column up so all the rows align?

sample report:
pitcher catcher 1stbase
........................hall
............smith
jones

I WANT IT TO LOOK LIKE THIS:
pitcher catcher 1stbase
jones smith hall

hopefully this make sense to someone, i've been playing for awhile with no luck. i'm sure it will be something simple for most of you experts....i'm trying! thanks for all your help.

 

[Isskint]

create 3 seperate reports for each position. Then create a 4th master report, and put each of the seperate reports as sub reports.