A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need Help Formatting Report



 
 
Thread Tools Display Modes
  #1  
Old July 5th, 2007, 02:42 PM posted to microsoft.public.access.reports
DKG
external usenet poster
 
Posts: 2
Default Need Help Formatting Report

I have a 3 column report. I want the fields in the 3 columns to line up but
don't know how to do this.

For example, right now my report looks like this: Note where Field 2 is
appearing in Column 2. I want it to line up with the other field 2's in
Columns 1 & 3. In other words, I want ALL the fields to line up in a row so
you could use a ruler and read report data.

Column 1 Column 2 Column 3
field 1 field 1 field 1
field 2 field 2
field 3 field 2 field 3
field 4 field 3 Field 4
  #2  
Old July 5th, 2007, 05:06 PM posted to microsoft.public.access.reports
Bruce Meneghin
external usenet poster
 
Posts: 119
Default Need Help Formatting Report

I think you'll need to provide more info on the source table/query to help us
understand how you are getting your current results.
Bruce

"DKG" wrote:

I have a 3 column report. I want the fields in the 3 columns to line up but
don't know how to do this.

For example, right now my report looks like this: Note where Field 2 is
appearing in Column 2. I want it to line up with the other field 2's in
Columns 1 & 3. In other words, I want ALL the fields to line up in a row so
you could use a ruler and read report data.

Column 1 Column 2 Column 3
field 1 field 1 field 1
field 2 field 2
field 3 field 2 field 3
field 4 field 3 Field 4

  #3  
Old July 15th, 2007, 02:18 PM posted to microsoft.public.access.reports
DKG
external usenet poster
 
Posts: 2
Default Need Help Formatting Report

I didn't explain things very well. I need to have a Report line up all the
fields. I have 3 columns and there is no problem with the format/layout of
the columns; however I cannot increase the column sizes or things won't fit
on the page. The problem occurs if you try to read the information on a
"line by line basis" or by "rows" -- some field information lines up by "row"
or "on a line by line" basis, some does not.

For Example:
Column 1 Column 2 Column 3
Name Name Name This "row" lines up; you could put
a ruler under it
Address * Address * Address in Column 2 does NOT
line up where
City Address City Address is showing up in
the other columns



"Bruce Meneghin" wrote:

I think you'll need to provide more info on the source table/query to help us
understand how you are getting your current results.
Bruce

"DKG" wrote:

I have a 3 column report. I want the fields in the 3 columns to line up but
don't know how to do this.

For example, right now my report looks like this: Note where Field 2 is
appearing in Column 2. I want it to line up with the other field 2's in
Columns 1 & 3. In other words, I want ALL the fields to line up in a row so
you could use a ruler and read report data.

Column 1 Column 2 Column 3
field 1 field 1 field 1
field 2 field 2
field 3 field 2 field 3
field 4 field 3 Field 4

  #4  
Old July 16th, 2007, 03:02 AM posted to microsoft.public.access.reports
Chuck
external usenet poster
 
Posts: 261
Default Need Help Formatting Report

On Sun, 15 Jul 2007 06:18:02 -0700, DKG wrote:

I didn't explain things very well. I need to have a Report line up all the
fields. I have 3 columns and there is no problem with the format/layout of
the columns; however I cannot increase the column sizes or things won't fit
on the page. The problem occurs if you try to read the information on a
"line by line basis" or by "rows" -- some field information lines up by "row"
or "on a line by line" basis, some does not.

For Example:
Column 1 Column 2 Column 3
Name Name Name This "row" lines up; you could put
a ruler under it
Address * Address * Address in Column 2 does NOT
line up where
City Address City Address is showing up in
the other columns



"Bruce Meneghin" wrote:

I think you'll need to provide more info on the source table/query to help us
understand how you are getting your current results.
Bruce

"DKG" wrote:

I have a 3 column report. I want the fields in the 3 columns to line up but
don't know how to do this.

For example, right now my report looks like this: Note where Field 2 is
appearing in Column 2. I want it to line up with the other field 2's in
Columns 1 & 3. In other words, I want ALL the fields to line up in a row so
you could use a ruler and read report data.

Column 1 Column 2 Column 3
field 1 field 1 field 1
field 2 field 2
field 3 field 2 field 3
field 4 field 3 Field 4


Try doubling the width of Column 2 and see what happens.

Chuck
--
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.