getting multiple fields onto a single line

[Steve Leferve]

Hey folks -

I have a table for reviewer comments. There is a field called 'txtComment'
where it stores a one-sentence comment.

In the report, we have these grouped and broken down by category id. Right
now they are line items. I would like to have each comment run together, so
that they appear as a paragraph, and not each field on a single line.

Whereas now it's:
Server was friendly.
Server upsold beverage.
French Fries were cold.

We would like
Server was friendly. Server upsold beverage. French Fries were cold.

How do I do this?

Steve

[Douglas J. Steele]

See whether you can modify the code in
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web" to meet
your requirements.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Steve Leferve" <le********@osu.edu> wrote in message
news:c5**********@charm.magnus.acs.ohio-state.edu...

Hey folks -

I have a table for reviewer comments. There is a field called 'txtComment'
where it stores a one-sentence comment.

In the report, we have these grouped and broken down by category id. Right
now they are line items. I would like to have each comment run together, so that they appear as a paragraph, and not each field on a single line.

Whereas now it's:
Server was friendly.
Server upsold beverage.
French Fries were cold.

We would like
Server was friendly. Server upsold beverage. French Fries were cold.

How do I do this?

Steve

[Pieter Linden]

Like this, maybe...
http://www.mvps.org/access/modules/mdl0008.htm