ms access print multiple Report pages per single output page

  • Thread starter Thread starter Guest
  • Start date Start date
Print the report to a PDF file. Then print from Acrobat reader and you
can get up to 16 pages on one page.
 
I am sorry I guess I have over simplified my question. I have created a
report that shows certain information. What I need is to print certain pages
twice depending on a certain value from the database. I need this to be sent
to a impact printer
 
I don't think there is a simple solution for printing specific pages more
than once. There might be a simple solution to printing specific records
more than once. Can you tell us if "page" is your actual criteria or can the
number of pages be specified by records and data?

You stated "certain value from the database" which isn't too specific since
a database contains tables, queries, forms, reports, code,....
 
The report itself is a inspection report based on a query. What I need is if
the discipline is B and the value is >= 400 print two copies of this
inspection report.
 
Before I take the time to answer, are you just wishing to print multiple
copies of a report based on a value in some field from some table that might
or might not be in the record source of the report?
 
No I am not just wishing. And the values are in a table. The reason I am
being a little vague is for privacy reasons. The report will run as a batch
and each page will print information based on a discipline. When the
discipline on a page changes to B (yes this is a real value on a real table
in a real database) and the work value is greater than or equal to $400.00 I
want to print two copies of that page else just print one. That's it I
cannot simplify this any more. If you cannot help me I will try another way
which will create more work but will get the results I am looking for

Regards
 
You have waivered between "print certain pages twice " to "print two copies
of this inspection report" to "print two copies of that page" while never
providing a concise explaination like:

I have an inspection report based various disciplines. Each discipline is
printed on its own page. When the value of the field [discipline] equals "B"
and the value in the field [Work] >=400 then print that discipline twice.
All other values of discipline and work will always, for ever only need to
print a single copy of the discipline.
 
I appreciate that you have finally understood my problem. However, you have
not provided an answer to my problem. I am very sorry that I have wasted
your time and mine Next time I will be more precise so that we don't have to
go back and forth for a grammer lesson.


Duane Hookom said:
You have waivered between "print certain pages twice " to "print two copies
of this inspection report" to "print two copies of that page" while never
providing a concise explaination like:

I have an inspection report based various disciplines. Each discipline is
printed on its own page. When the value of the field [discipline] equals "B"
and the value in the field [Work] >=400 then print that discipline twice.
All other values of discipline and work will always, for ever only need to
print a single copy of the discipline.

--
Duane Hookom
MS Access MVP
--

vbnovice said:
No I am not just wishing. And the values are in a table. The reason I am
being a little vague is for privacy reasons. The report will run as a
batch
and each page will print information based on a discipline. When the
discipline on a page changes to B (yes this is a real value on a real
table
in a real database) and the work value is greater than or equal to $400.00
I
want to print two copies of that page else just print one. That's it I
cannot simplify this any more. If you cannot help me I will try another
way
which will create more work but will get the results I am looking for

Regards
 
I don't think progressing from "How?" to an accurate description of what you
have and what you need suggests this is a "grammer lesson".

Your posting "I have resolved this on my own and my report is working the
way I want it to" suggests you have found your own solution that meets your
needs. I wasn't about to spend more time finding a flexible, workable method
when you no longer need it.

I did want you to understand the "scope" of your first question limited
possible answers to about about a 70,000,000 results in Google. With some
additional replies to questions and clarifications of "Pages" and "value
from the database" vs field names(?) and values it seems that your
conditions and specifications might have been discovered.

I am sorry if I seem a bit demanding. I read 1,000s of posts each week and
like to help out where possible. When I read the body of a post that states
"How?" I get a mildly confused. I'm not sure how someone can expect others
to spend some time replying to a question when the original poster doesn't
seem to have time to type in enough information to allow others to venture
more than a WAG.

--
Duane Hookom
MS Access MVP
--

vbnovice said:
I appreciate that you have finally understood my problem. However, you
have
not provided an answer to my problem. I am very sorry that I have wasted
your time and mine Next time I will be more precise so that we don't have
to
go back and forth for a grammer lesson.


Duane Hookom said:
You have waivered between "print certain pages twice " to "print two
copies
of this inspection report" to "print two copies of that page" while never
providing a concise explaination like:

I have an inspection report based various disciplines. Each discipline is
printed on its own page. When the value of the field [discipline] equals
"B"
and the value in the field [Work] >=400 then print that discipline twice.
All other values of discipline and work will always, for ever only need
to
print a single copy of the discipline.

--
Duane Hookom
MS Access MVP
--

vbnovice said:
No I am not just wishing. And the values are in a table. The reason I
am
being a little vague is for privacy reasons. The report will run as a
batch
and each page will print information based on a discipline. When the
discipline on a page changes to B (yes this is a real value on a real
table
in a real database) and the work value is greater than or equal to
$400.00
I
want to print two copies of that page else just print one. That's it I
cannot simplify this any more. If you cannot help me I will try
another
way
which will create more work but will get the results I am looking for

Regards

:

Before I take the time to answer, are you just wishing to print
multiple
copies of a report based on a value in some field from some table that
might
or might not be in the record source of the report?

--
Duane Hookom
MS Access MVP
--

The report itself is a inspection report based on a query. What I
need
is
if
the discipline is B and the value is >= 400 print two copies of this
inspection report.

:

I don't think there is a simple solution for printing specific
pages
more
than once. There might be a simple solution to printing specific
records
more than once. Can you tell us if "page" is your actual criteria
or
can
the
number of pages be specified by records and data?

You stated "certain value from the database" which isn't too
specific
since
a database contains tables, queries, forms, reports, code,....

--
Duane Hookom
MS Access MVP
--

I am sorry I guess I have over simplified my question. I have
created a
report that shows certain information. What I need is to print
certain
pages
twice depending on a certain value from the database. I need
this
to
be
sent
to a impact printer

:

How?
 
Back
Top