jleist1530
New member
- Local time
- Today, 05:49
- Joined
- Jul 8, 2010
- Messages
- 2
I am trying to make a summary of item information.
I have three tables a master table with everything, and two other tables. One contains sales information and one contains information on what is used in manufacturing the product.
I am trying to create a report that shows item, item description, sales information (current year by month and prior year by month) as well as the compotents that are used in manufacturing the product.
I have inserted a subform that i thought would list the components used for a specific item number but it just lists all the components and never breaks for a new item. The sales information is on the main report since it's from a different query.
This is really frustrating me. I don't like code and I want to use just design view to create the report. Any help is greatly appreciated!
I have three tables a master table with everything, and two other tables. One contains sales information and one contains information on what is used in manufacturing the product.
I am trying to create a report that shows item, item description, sales information (current year by month and prior year by month) as well as the compotents that are used in manufacturing the product.
I have inserted a subform that i thought would list the components used for a specific item number but it just lists all the components and never breaks for a new item. The sales information is on the main report since it's from a different query.
This is really frustrating me. I don't like code and I want to use just design view to create the report. Any help is greatly appreciated!
