Two Columns in One page on a Report

J

jeanhurtado

Hi, I'm Jean want to know if possible to make to columns in a page on
a Report. An example:

Line Ticket Part Number Counted By Remarks Line
Ticket Part Number Counted By Remarks
1 101 000 JCA N/
A 3 103 001
JCA N/A
2 102 001 JCA N/
A 4 104 004
JCA N/A



Following the Order of the Ticket number.. This report depend on a
query called Final Cycle Count Report.
I want 100 record show in that page. So line will go from 1 -100. How
I can make this? First column from 1 to 50
and the second column from 51 to 100.


Thanks for all.


Jean C.
 
F

fredg

Hi, I'm Jean want to know if possible to make to columns in a page on
a Report. An example:

Line Ticket Part Number Counted By Remarks Line
Ticket Part Number Counted By Remarks
1 101 000 JCA N/
A 3 103 001
JCA N/A
2 102 001 JCA N/
A 4 104 004
JCA N/A

Following the Order of the Ticket number.. This report depend on a
query called Final Cycle Count Report.
I want 100 record show in that page. So line will go from 1 -100. How
I can make this? First column from 1 to 50
and the second column from 51 to 100.

Thanks for all.

Jean C.

In Report Design View, click on
File + Page Setup + Columns
Enter 2 as the number of columns.

Depending upon your report layout, ether set the Column Width "Same as
Detail" check box to Checked or uncheck the box and enter the wanted
column width manually.

Set the Column Layout to Down then Across.
You'll have to adjust the detail height so that it will print 50
records down.
 

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