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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
I have reviewed the code of that example, and have tried to apply certain
attributes to it, but without any success so far!
 
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.
 
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.
 
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] & """")
 
Back
Top