Report With Multiple Image Pages Following Each Group

[chaddiesel]

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 table 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.

Part Description Table
------------------------------------------
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:


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

Page 3
------------------------------------
Part 3 Drawing

Page 4
------------------------------------
Part Group BBB

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


Like I said, I might not have an equal amount of drawings and part numbers, and I want to print multiple drawing pages after each group. If there are no drawings for that group, I don't want any blank pages printed. Those are the parts that are confusing me. I don't know how to group one group per page and have the drawings follow that page. I can't think of how to set up this. I hope I am making sense (probably not ).
You might wonder why I am linking to drawings in Excel files. My boss wants to just be able to drop a new Excel file in a specific folder when the drawing changes.

I would appreciate it if someone could point me in the right direction.

Thanks,

Chad