If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need Help With Multiple Pages After Groups
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... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Page Setup Across Multiple Pages | Ben | Visio | 3 | June 20th, 2005 03:46 PM |
Enabling multiple pages for a multiple pivot chart | HubbyDaddy | Setting Up & Running Reports | 0 | June 1st, 2005 12:04 AM |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
How do I remove multiple text boxes on multiple pages after expor. | Word expert needed | Page Layout | 1 | November 20th, 2004 11:50 PM |