This is my first time to post in Reports. I'm usually more concerned with forms. I keep running into this scenario:
say for example, there is 1 table and 1 subtable (or more). the first table table [tProductInfo] has (1) entry. The 1st subtable [stLots] contains 2 (or more) entries that correspond with the primary key field in table tProducts. On top of this, a 3rd table, [tPalletNumbers] contains 10 entries (for the 10 pallets that went on Hold).
the 2nd and 3rd tables have a Many-to-One relationship with tProductInfo.
When I create the report by querying all 3 tables, I will always get multiple entries of the same data. If some of the pallet numbers were for one lot and the rest were for another, I would want to see 2 lines, with each line just summing the total number of pallets. But Access will display a separate row for each row in every table where the primary key is the same as the query.
Any takers? Thanks.
say for example, there is 1 table and 1 subtable (or more). the first table table [tProductInfo] has (1) entry. The 1st subtable [stLots] contains 2 (or more) entries that correspond with the primary key field in table tProducts. On top of this, a 3rd table, [tPalletNumbers] contains 10 entries (for the 10 pallets that went on Hold).
the 2nd and 3rd tables have a Many-to-One relationship with tProductInfo.
When I create the report by querying all 3 tables, I will always get multiple entries of the same data. If some of the pallet numbers were for one lot and the rest were for another, I would want to see 2 lines, with each line just summing the total number of pallets. But Access will display a separate row for each row in every table where the primary key is the same as the query.
Any takers? Thanks.