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 list 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 would really appreciate some
help.

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