G
Guest
How?
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
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?