Multiple columns in a report

[JHeck127]

I have a database full of names and other information.
I was wondering how i would be able to make my one list of names into 2 or 3. I have tried as many things as i can think of, without success. I want the names to go
ABC District XYZ School john adams jill aveeno
jim bryant
TUV School Bill abrahms etc.
DEF District MNO School ...
So the second column pulls the "even" names while the "odd" names go in the first column. But then i want the names to stop when the District/School name changes.

 

[dhookom]

Use a multicolumn subreport for the list of names. Make sure you remove the name detail records from the main report's record source query. Set the link master/child properties to the School field.


Duane
Hook'D on Access
MS Access MVP