Printing the same stuff on the second half of the page

  • Thread starter Thread starter Fiaz Idris
  • Start date Start date
F

Fiaz Idris

I am an access newbie.

I have created report from a query which has 280 records.

I have managed to fit the data in 6 columns x 50 rows with in one half of
the landscape orientation A4 page. (20 blank cells in the last column.)

If the data is going to get more than 300 records, the rest of the records
should simply be ignored.

Now I need to have the same thing (that is duplicated) printed on
from Column 7 - Column 12 in order to save paper. The user can tear
off the landscape in half for operations use.

How can this be achieved in the simplest of ways?

+------------------------------------+
|1 |51 ||1 |51 |
|2 ||2 |
|3 ||3 |
|4 ||4 |
|5 ||5 | 50 rows
| || |
| || |
| || |
| || |
| || |
|50 ||50 |
+------------------------------------+
6 columns || 6 columns


A4 Landscape Orientation
Data from a query which has 280 records

Any help would be appreciated.
 
You have already set up the report to use half the width of the landscape
paper (less margins), and you want to print two columns of data, side by
side?

If that's the idea, open your report in Design View.
Choose Page Setup from the File menu.
On the Columns tab, specify 2 columns.

Make sure the width of the detail section is not more than:
(width of the paper - left margin - right magin) / 2 - column spacing.

I don't think you wanted to print two identifical copies of the same thing,
but that could be done by making a table containing just 2 records, and
adding it to the report's query, without any join lines between this one and
the other tables.
 
I don't think you wanted to print two identifical copies of the same thing,
but that could be done by making a table containing just 2 records, and
adding it to the report's query, without any join lines between this one and
the other tables.
Click to expand...

In fact, that is exactly what I want.

I wanted two identical copies of the same thing on each of the halves.

Could you be more specific in helping me accomplish the task.

Currently, the data for the report comes from a single query.
 
Create a table with just one field, of type Number, named (say) "CountID".
Save the table, and enter 2 records (say 1, and 2).

Create a query that contains the table for your report if you don't already
have one. Drag this table in. Since there is no join between this table and
the other table(s) in the query, you will get every record twice in your
query.

Now that you have 2 copies of every record, it is easy enough to set up the
2 column report (File | Page Setup | Columns), and then sort the report so
the 2 records occur correctly. To sort the records within your report use
the CountID field in the Sorting And Grouping dialog (View menu in report
design view.)
 
Fiaz:

If you want to identical copies of the same report on two halves of paper,
create a new report and add your existing report twice as a subreport on the
new main report. It will print out twice.
 
Thanks to both Allen & SA.

I managed to follow the instructions from both of you, but
there is a problem with each method. Do advise how I might be
able to overcome?

Allen

I did it your way and it infact has two copies of the same report
using the grouping, etc. But, The second set, starts immediately
on the next column. I.e.

Assuming the query returns 230 x 2 results. I want the second set
to start on Column 7 Row 1, but following your method, the second set
starts in Column 6 Row 1.

Also, If the query returns more than 300 x 2 results, only the first
300 needs to be displayed on each half and the remaining data can be simply
ignored.

The correct way as I expect it to be.

Column:
+ 1| 2| 3| 4| 5| 6|| 7| 8| 9| 10| 11| 12+
+--------------------------------------------------+
|1 | 51|101|151|201| || 1 | 51|101|151|201|251|
| || |
| || |
| || |
| || |
| |230| || |230| | 50 rows
| || |
| || |
| || |
|50 | || 50 | |
+--------------------------------------------------+
6 columns || 6 columns


FYI, the reason for setting up the page layout in the above format
is to have the operation staff tear the page in half and each half
has got the same set of data. (I want the whole stuff on a single page)


SA

Usig your way I am able to control where the second half starts, but
then on each of the halves, the data runs through to to the next page
instead of wrapping to the next column. I.e.

--Page 1--------------------------
1 || 1
2 || 2
3 || 3



50 ||50
-- Page 2-------------------------
51 ||51
52 ||52
.... ||...
.... ||...
.... ||...


and so on

Sorry, if I am such a pain.
 
You should be able to use Columns in the subreport Steve suggested.

You can limit the query to only 300 records if you set its Top Values
property. Use the Properties box in Query Design view, or in SQL View use:
SELECT TOP 300 ...
 
Allen Browne said:
You should be able to use Columns in the subreport Steve suggested.

You can limit the query to only 300 records if you set its Top Values
property. Use the Properties box in Query Design view, or in SQL View use:
SELECT TOP 300 ...
Click to expand...

I happen to solve the problem now and thanks to both of you.

Infact, from what I gathered in newsgroup and elsewhere. It is an
Access2000 glitch that will not let you snake columns when you
print "down then across" with in a subreport though it works on the
main report.

See the kbase article as "Q208364"
http://www.kbalertz.com/Feedback_208364.aspx

And I found the following solution from the newsgroup by someone and
he has quote as below:

QUOTE:
I don't generally deal with snaking columns and not too sure of what you
are doing, but I think I can give a good guess that may help.

Try vertically sizing the subform to fill a page and set the CanGrow
Property to No. You may have to play with the size until it fits
properly on the printout, or it may not even be viable, but won't hurt
to try it.
UNQUOTE:

So the solution is to "down then across" change the CanGrow property
of the subreport to "No". You also have to adjust the "height" and "width"
of the subreport to make it fit on one page.

Newsgroups are such a wonder.
 
Back
Top