produce report with results across screen, rather than row by row

[Guest]

I am wanting to produce a report that is listed by category, but at the
moment this is what i get:

depot name
bus type
bus # 1
bus # 2
bus # 3
bus # 4

but what i'm wanting is this:

depot name bus type bus #1, bus #2, bus #3, bus #4

so where it lists bus #, without the comma between each detail, i want it to
go across the page X amount of times, then if there are more than 1 row of
results, it then continues down on the next row starting at the tabbed
position.

I hope this helps, if it doesn't make sense, please leave details and I
shall email you what I currently get, and what i'm wanting.

Thankyou in advance

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

I have reviewed the code of that example, and have tried to apply certain
attributes to it, but without any success so far!

 

[Duane Hookom]

If you can't figure out the code, don't post what you tried, and don't post
the table structures with field names and data types, then it is a bit
difficult to help.

One other WAG is to create a multi-column subreport.

 

[Guest]

You mention a multi-column subreport! I understand what a subreport can do,
but unsure how I can get the data to go across the screen then down to the
next line at the page margin rather than row by row!

With the example you gave earlier, I noticed that there was a module in
there. That was the part I was trying to understand as it kept saying
concatenate on the form, so I thought that the module was involved in
producing the reports, thats the part I got lost on.

 

[Duane Hookom]

The bus #s are in a subreport placed to the right of bus type.
depot name bus type [bus #1, bus #2, bus #3, bus #4]

The code method uses a text box bound to an expression like:
=Concatenate("SELECT BusNum From tblBusStops Where DepotName=""" &
[DeptName] & """")