PROBLEM: Making form/report with a fixed no. of lines and variable no. or records

I understood.
Thank you!!!
I think I didn't read with enough attention at first.Sory!
"SA" wrote in message
...
Chris:

(HTML Deleted)

Add a Group (using the sorting and grouping dialog) for the Product code
and
for the OrderID and be sure to set that each group has a group header.
You
don't need to have any data in these groups, it can all be in the headers
and detail lines. Then click on the group header in design mode, bring
up
its properties and for the Force New Page property. Set it to before
section.
--
Steve Arbaugh
MS Access MVP


"Chris" wrote in message
...
Thank you very much. I inderstood this part.
But how about generating a new page for every new product code and
eventualy
every order ? This code must appear in the header, not in the report body.
Like this (rich text-HTML):


HEADER:
Company .....................Order ...................
Exit document
Document
numberDate PRODUCT CODENo. of items

daymonthyear
............ ................. .......... .........
.......................... ..........................
Crt.
no.
.
The name and the characteristics of the materialAccountThe Code of the
aterial Qt.Measurement unit
Unit
Price
Total Price
DebitorCreditor
BODY(the values)
1....
2....
3....
4.
5.
6.
7.

FOOTER:
Date: ........................
Department's chief signatureStock keeper signatureMaterial user's
signature





The beneficiary of the database, the chief of mechanical deparment wants
even more repports on one A4 page, till fiting the dimension of the page
(I
sugested to use A5 pages with one report centered)
Thank you,
Chris

"Steve Schapel" wrote in message
...
Chris,

Yes, you would have to set up a procedure to remove the blank lines and
rewrite them to the table in response to changes in other data and
requirements. I don't really see this is too much of a problem that you
need to cater for this for each product. You will just have to work on
getting the relevant Delete and Append queries set up correctly, and the
procedures to run them. But in the end, you need 7 records in the table
for each product, so the requirement will be, whenever there is a
relevant change in the "real" data for one of the products:
- a delete query to remove the "blanks" for that ProductID
- obtain a count of the "real" records for that ProductID
- an append query to add the required number of blanks for that
ProductID

--
Steve Schapel, Microsoft Access MVP


Chris wrote:
What if, after viewing that report I see that I forgot to add a record
and I
have to do it? I use a delete query to del. the "blank" lines, I add a
record from the front end form and than add again "blank"lines?

2. One more BIG PROBLEM !!! I need to make this report multipage, and
a
new
page for each new value for one of the parameters.(The database is for
the
stockpile, and these reports must be exit tickets for the materials
from
the
storage.
For any product -having a code- i take from the storage some
materials.When
that code is changed, it need to be generate a new page of the report,
and
any af them with 2, 3, 4 (maximum 7) lines written (as many materials
are
taken for that product code) and the rest of the lines, to 7, blanks.