Columns in report

[Rachel B.]

I am trying to get my data from my query to group into two columns.

Name Name
Date Time Date Time
Address Address
City, State Zip City, State Zip
Phone Phone

Name Name
Date Time Date Time
Address Address
City, State Zip City, State Zip
Phone Phone

Like the above example. I set the page set up to 2 columns but it still
just puts the info into one column. I want the header and footer to be full
page (not in columns) just the "details" to be in two columns. I can't seem
to get it to work. Any help would be appreciated.

 

[Jeff Boyce]

Rachel

"How" depends on "which"...

Which version of Access are you using?

(p.s., are you looking at Report Header/Footer or Page Header/Footer?)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rachel B.]

I am using Access 2007 and It has
Report Header
Pager Header
Detail *this is the section I would like in 2 columns
Page Footer
Report Footer

The report is from a query.

Thanks.

 

[Jeff Boyce]

Open the report in design view.

Select the <Report Design Tools> tab, then the <Page Setup> tab.

Select the <Columns> toolbar button, then the <Columns> tab. Set your
columns.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rachel B.]

Yeah. Tried that. It doesn't create two columns. I thought that perhaps I
was doing something wrong... Nothing changes/happens when I add columns.
What am I doing wrong?

 

[Jeff Boyce]

No idea. We've exhausted my experience!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Rachel B.]

CAN ANYONE PLEASE HELP ME. PAGE LAYOUT WILL NOT CREATE COLUMNS!

 

[Jeff Boyce]

Rachel

A thought just occurred to me ... is this a report that you've had before,
or have you tried creating a brand new report definition?

Also, do you have Track Name Autocorrect turned on? Having this "on" has
created problems in report definitions in some versions of Access.

Note: ALL CAPS ARE CONSIDERED SHOUTING, an impolite form of address in an
all-volunteer newsgroup like this one.

Consider posting a new item, rather than relying on folks to search all the
way down this thread.

Good luck!


Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

Did the poster change the column widths to something like 3.5 inches instead
of the default width (all the available width)?

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County