Report Columns

J

Jason

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
 
A

Al Campagna

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....
--
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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top