Report format, all on one line

[Lifeseeker]

Hi,

Currently, I have a report that's formatted as follows:

Facility #: Serial #
L1030
90345
35232
234232

L3534 90345
34523
23423

Is it possible to get Access to display those Serial numbers all in one line without changing database structure? I'm thinking this is solely a report formatting issue...but I'm a little unsure.

So the desired output format is....

L1030 90345, 3532, 23422, ect.

All the serial # are 5-digit.

Could anyone help me on this? Any way around this?

 

[pbaldy]

This sort of thing?

http://www.mvps.org/access/modules/mdl0004.htm