Also... apparently my code to hide sales information for the components did not work, it reappears at the top of each page. I think I will I need a separate table...what do you think? One that contains component information and one that contains Sales information in order to get both pieces of information on there without it repeating itself...?

Right now this is a snippet of the table I have

Item Number / Sales / Component...

Thanks! Now I have a bigger issue. How do I get ride of blank space? I have sales information that is being hidden when Is Null but it leaves a bunch of space and my components listed for each item number are being spaced too far out. it's on 11x17 paper. So I want component information listed on the left and the sales information on the right but for each component listed there is a bunch of space where the sales information is hidden because it...

it's a lot.... i am dealing with the Item Number and the Component Item Number. Each Item Number might be associated with anywhere from 0-20 different Component Item Numbers so there can be 0-20 of the same Item Number listed. I just want a list of the Component Item Numbers for the Item Number they pertain to.

Does this make sense?

Thanks,

JLeist

I am relatively new to Access and I am using the 2003 version.

Here is my issue:

I have a report that is a summary of the products we manufacture. On the report I want it to list the components needed to make the item. I am using one master table to pull the information from. However, when I run the report it doesnt list the different components, it gives a new page for each component and i dont want that. Thanks...