Displaying Data Horizontally

[BobB]

I need help with this problem also. The example I can provide is as follows:

simple database with 2 tables, DriverSettlement and DriverOrders.

DriverID is the linking field. DriverOrders contains detail data in field
TagID.

The report is to display Driver Tag IDs by OrderDate for each driver (this
is a Settlement report for Courier Drivers).

Example:

Driver Number 001 Name Hester Jones

November 1, 2003 Orders for the Day

320593 320596 320639 321606
321700 (etc.



The TagID field contains in each record an order number (320593 example
above). Normally the numbers are displayed vertically in the detail section
of the report. I want them to display horizontally.

I have been toying with the idea of creating a subreport set up as a mailing
label. I think I'm on the right track, but haven't been able to get it to
work right yet.

Thanks for any help.

BobB

 

[Allen Browne]

You may be able to get this to work with a multi-column subreport (File |
Page Setup | Columns).

Alternatively, you could concatenate the values programmatically as
described at:
http://www.mvps.org/access/modules/mdl0004.htm