Formatting list of text values in a report

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

Guest

Hi. I'm a very novice Access user who inherited a database developed by
another very novice Access user, and I need help. I have a report that runs
off of a query that links two tables. One table has facility information and
the other has information on services provided by that facility. There are
only 3 services and each facility offers at least one.

The existing report has the following:
FACINFO Header: Contains facility details like permit no, name, address, etc.
Type Header: Contains type of service(s) supplied.
Detail: Contains nothing
FACINFO Footer: Contains expiration date and other details associate with
facility.

This format has worked just fine until now ... because ... for some reason,
management decided to buy watermarked paper on which to print and the paper
was designed such that the expiration date appears within an image in the
watermark.

The problem that I am not equipped to resolve is that the section with the
Type information prints like the following:

TYPE
TYPE
TYPE

And this can be anywhere from one to three lines, which is NOT working with
the watermark. So, finally ... the question ...

Is there an easy way to format that field in the report to print like:

TYPE, TYPE, TYPE

Thanks!
FixItEvenIfYouDon'tKnowHow Girl
 
Sooo ... no response ... does this mean that my question is inappropriately
easy and even us novice folks should know the answer? If the answer is that
obvious, I'd love a shove in the right direction for appropriate help.
Thanks.
 
Back
Top