Report Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason - 12 Dec 2007 16:24 GMT

I am trying to add columns to my report but am having some difficulty. The
report is basically a form letter. It is grouped on the employee’s unique ID.
In that group header is the letter, Dear so and so etc. It is the details
portion that I am trying to get into two columns. Is there something I am
missing on how to do this. I would rather no put a sub report in to
accomplish this.

Thank you

Reply to this Message

Al Campagna - 12 Dec 2007 21:57 GMT

Jason,
Well, the subform would be an easy way to go about that.
However, I would think you could use the ID group header to display the
first part of the letter, the detail section to display the multi-column
data, and the ID footer to display the last half of the letter.
ID Group Header----------------------
Dear Sirs:
First part of letter Text
Detail-------------------------
Col1 Col2 Col3
ID Group Footer--------------------------
Last portion of the canned letter.

I didn't test, but that should work....

Signature

hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

>I am trying to add columns to my report but am having some difficulty. The
> report is basically a form letter. It is grouped on the employee's unique
[quoted text clipped - 5 lines]
>
> Thank you

Reply to this Message