Mager-chan
08-21-2002, 02:30 PM
Hello,
I am building an Access database that will keep track of Silicone product Inventory in two seperate warehouses. IT has an Customer Order Form, Purchases Form, and Transfers Form that all feed into calculating the Inventory.
Right now I am trying to create a Report that will Show the Product ID (ID Used in Inventory Table to identify each product).
as the "Report Header" then in the details section of the report it will show every order placed for that product.
You will probably need a little information as to how the order information is taken, Well...There is a Customer Orders Form...which takes into consideration the Customer Name, ID, Ours Sales Order Number, and The Date.
Then there is a Subform named OrdersDetailsSubform, it references through the Sales Order Number, and takes in the Product ID, Amount Shipped From Each Warehouse, Shipping Method, and Sales Rep ID.
I have attempted to create the report I am trying to make in 2 different ways. The first was through a query that included all the above fields, I seperated the Report solely by the Product ID, and put the rest of the fields in the Details section, It give me the data, but If there was more than one product sold on a specific Sales Order, then the sales order is repeated in the details section that (the number of different Products sold on that sales order) many times....
So for instance If i sold 1 drum ICM SF-350 to Company A on Sales order 101, and sold them ICM SF-1000 on that same sales order, then in my report under Product ICM SF-350 under the details section its shows 1 drum of ICM SF-350 To Company A on Sales order 101, and then on the next line shows 1 drum of ICM SF-350 to Company A on Sales order 101 again.
I am pretty sure that is clear.
The second attempt was to just make the report based on the 3 tables...Inventory, Orders and OrdersDetails. This resulted in the same outcome.
So...now that you know what is going on, how do i stop this from happening...Any and all help is most appreciated.
Thank You.
Michael
I am building an Access database that will keep track of Silicone product Inventory in two seperate warehouses. IT has an Customer Order Form, Purchases Form, and Transfers Form that all feed into calculating the Inventory.
Right now I am trying to create a Report that will Show the Product ID (ID Used in Inventory Table to identify each product).
as the "Report Header" then in the details section of the report it will show every order placed for that product.
You will probably need a little information as to how the order information is taken, Well...There is a Customer Orders Form...which takes into consideration the Customer Name, ID, Ours Sales Order Number, and The Date.
Then there is a Subform named OrdersDetailsSubform, it references through the Sales Order Number, and takes in the Product ID, Amount Shipped From Each Warehouse, Shipping Method, and Sales Rep ID.
I have attempted to create the report I am trying to make in 2 different ways. The first was through a query that included all the above fields, I seperated the Report solely by the Product ID, and put the rest of the fields in the Details section, It give me the data, but If there was more than one product sold on a specific Sales Order, then the sales order is repeated in the details section that (the number of different Products sold on that sales order) many times....
So for instance If i sold 1 drum ICM SF-350 to Company A on Sales order 101, and sold them ICM SF-1000 on that same sales order, then in my report under Product ICM SF-350 under the details section its shows 1 drum of ICM SF-350 To Company A on Sales order 101, and then on the next line shows 1 drum of ICM SF-350 to Company A on Sales order 101 again.
I am pretty sure that is clear.
The second attempt was to just make the report based on the 3 tables...Inventory, Orders and OrdersDetails. This resulted in the same outcome.
So...now that you know what is going on, how do i stop this from happening...Any and all help is most appreciated.
Thank You.
Michael