Report contains repeat lines of data...

[QMDirk]

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.

 

[Minty]

There is an option to hide duplicates in reports, and to grow/shrink in text boxes. It doesn't work on forms, but it DOES work on reports.
Have a play, and also look into sub-reports where you can not display on no data.

 

[arnelgp]

if you have Autonumber or Date/Time fields in your table, don't include them in the Query's output.

 

[HalloweenWeed]

When I create the report by querying all 3 tables

Don't do that. Use a query to query all 3 tables, then use the results in your report. You can then debug your query rather than debugging your report blindly.