how do you generate multi column reports?

[Wozzzzza]

i have hundreds of thumbnail images of people on the hard drive, they are named by their ID in a database. i want to be able to run a query and display in rows of about 6, pictures of the results of queries on a form. this result could be dozens of people at a time.
how do i do this?? i cant figure it out. need rows of pictures form an ID returned in a query.
I can do this with a single photo on a report one under each other in rows of one but cant figure out how to do it on a report in rows of 6.

 

[Galaxiom]

Use subreports to create the columns.

Allocate a number to the records in the main record source. Then use the Mod function to allocate a column based based on this number.

Use Mod field in the subreport query to select the records for each column.

 

[Wozzzzza]

Use subreports to create the columns.

Allocate a number to the records in the main record source. Then use the Mod function to allocate a column based based on this number.

my memory is jogged, yes i can use subreports, i remember now.
as for allocating a number ot the records, how can i do this? the report source is a query, i cant get an autonumber occuring in a query to be able to number each individual record, any clues how to do this??

 

[stopher]

Maybe I'm not understanding the problem but if you want your data to appear in columns, check out the Columns tab in the Page setup.

Chris

 

[Galaxiom]

Looks like Stopher is on the money. I was extrapolating from a technique to use columns on forms.

 

[Wozzzzza]

yes they do both ring a bell, been a while since i had to do this, but yes, page setup has it, making things easier.
when you dont do these certain functions for a long time you forget how you used to do them in the past.
but thanks to both, problem sorted.