I have a query that lists the individual quaintity and length data of lumber in a bundle (pack).
Each bundle has a unique number but it can have many length records depending of whats in the bundle. Some only have one, others can have ten, the average is about eight.
There are 3000 bundle numbers, but 25000 qty and length records related to each of these bundles.
In the report I only want to display one line per bundle number, with the various quaintity and length data displayed on the same line. See attached mockup.
Also attached is a screen shot of the data in the query, you can see that the first bundle number (PackNo) is repeated for twice, once each for each seperate qty and length data. The following bundles only have one record each.
Any idea how I do this?
I keep getting one line for every record, so 25000 lines rather than 3000 lines.
Thanks
JohnG
Each bundle has a unique number but it can have many length records depending of whats in the bundle. Some only have one, others can have ten, the average is about eight.
There are 3000 bundle numbers, but 25000 qty and length records related to each of these bundles.
In the report I only want to display one line per bundle number, with the various quaintity and length data displayed on the same line. See attached mockup.
Also attached is a screen shot of the data in the query, you can see that the first bundle number (PackNo) is repeated for twice, once each for each seperate qty and length data. The following bundles only have one record each.
Any idea how I do this?
I keep getting one line for every record, so 25000 lines rather than 3000 lines.
Thanks
JohnG