Need Help With Multiple Pages After Groups

[ChadDiesel]

Hello everyone,


I'm having a problem with Access that I need some help with. The short
version is, I want to print a list of parts and part quantities that belong
to a certain part group---One part group per page. I created a report that
groups
the parts by part classification group with a force new page after each
group. The report is based on a query of that week's orders. Some of these
parts have drawings (usually 2 each stored in an OLE link field) that need
to be included in the report. I want to print the needed drawings on
separate pages after each group of parts. I'm confused (about many things)
on how to set something like this up-especially printing multiple pages
after a group. I'm used to having a corresponding field for each record.
There might be 10 parts in the group, but only 2 might need drawings-maybe
none. I don't want to have a bunch of blank pages after each group. I'm
not having any luck printing out the drawings. I posted a more detailed
explanation below. Is it possible to do something like this, or would I
have to do separate reports for each group? I've tried a report with a
subreport in the group footer, but I haven't been able to get page breaks to
work in the subreport and I'm not sure if I need to link by Part Group or
Part Number. Maybe this is the wrong approach. I'm having a lot of trouble
with this, and I would really appreciate some help in pointing me in the
right direction.


Thanks,


Chad


Long Version:
------------------------------­--


I have a report that shows all the parts used in the previous week. It looks
something like this:


------------------------------­------
Part Group AAA


Part Number QTY
------------ -----
Part 1 23
Part 2 35
Part 3 48
Part 4 16
------------------------------­------


(****New Page*****)
Part Group BBB


Part Number QTY
------------ -----
Part 5 23
Part 6 35
Part 7 48
Part 8 16


------------------------------­-------


As you can see, I have the parts grouped in the report by Part Group they
belong to. I have each group on a separate page with group page breaks.


I have a query that contains the part number, its part group classification,
and an OLE Field that contains a link to an Excel spreadsheet which contains
a drawing file. I want to link the part numbers that show up in the report
query to the needed drawing in the table.

Query
------------------------------­------------
Part Number-----Part Group----Drawing


My situation is, I would like to include drawings for certain parts after
each group. What I want to do is print a page for each group followed by the
needed drawings-one on each page-not all parts have drawings:


Page 1
------------------------------­------
Part Group AAA


Part Number QTY
------------ -----
Part 1 23
Part 2 35
Part 3 48
Part 4 16
------------------------------­------


Page 2
------------------------------­------
Part 1 Drawing #1


Page 3
------------------------------­------
Part 1 Drawing #2


Page 4
------------------------------­------
Part 3 Drawing #1


Page 5
------------------------------­------
Part 3 Drawing #2


Page 6
------------------------------­------
Part Group BBB


Part Number QTY
------------ -----
Part 5 23
Part 6 35
Part 7 48
Part 8 16.
..
..
..
and so on...