Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report show two columns??

Status
Not open for further replies.

kayek

Programmer
Jun 19, 2003
95
US
Is there some way I can have my report have two columns? It should go to the next column instead of next page.

For example, I want my report to look like this:

Page 1
Abbrev State Abbrev State
------ ---------- ------ ----------
AL Alabama GA Georgia
AK Alaska GU Guam
AZ Arizona HI Hawaii
AR Arkansas ID Idaho
CA California IL Illinois
CO Colorado IN Indiana
CT Connecticut IA Iowa
DE Delaware KS Kansas
FL Florida LA Louisiana
KY Kentucky ME Maine

Page 2
Abbrev State Abbrev State
------ ---------- ------ ----------
MH Marshall Islands NH New Hampshire
MD Maryland NJ New Jersey
MA Massachusetts NM New Mexico
MI Michigan NY New York
MN Minnesota NC North Carolina
MS Mississippi ND North Dakota
MO Missouri OH Ohio
MT Montana OK Oklahoma
NE Nebraska OR Oregon
NV Nevada PA Pennsylvania

Page 3
Abbrev State Abbrev State
------ ---------- ------ ----------
PR Puerto Rico WV West Virginia
RI Rhode Island WI Wisconsin
SC South Carolina WY Wyoming
SD South Dakota
TN Tennessee
TX Texas
UT Utah
VT Vermont
VA Virginia
WA Washington
 
Select File|Page Setup|Columns and enter the number of columns and the Column Layout.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top