Horizontal data orientation

[Jbedelstein]

I am working on a report where I will need to print an invoice field's result horizontally.

Normally the report writer would list the data like this:

309501
309502
309503
309538

I want it to come out like this:

309501, 309502, 309503, 309538

I am planning to create a subreport for this section and the data will need to wrap to the next like when it reaches the right margin.

Is there an easy (or other) way to do this?
Thanks

 

[grnzbra]

You could open a recordset and loop through the records and concatinate the contents.

 

[Jbedelstein]

I thought that might be the way to do it. If I concatenate this with spaces between the values, will it wrap automatically? I'm still pretty new to Access. I'm working in 97, so do I use the DAO model?

Thanks

 

[grnzbra]

I think it will wrap, but I'm not sure. I think you can use DAO. Try it and see what happens.