Access report/HideDuplicates question

[Guest_imported]

I'm trying to create a report with 4 columns. The first two columns are from one table, i.e. one record/one row. The second two columns are from a related table, i.e. 1-3 rows per record of the first table. As an example (sorry about the monospace attempt),

Col1 Col2 Col3 Col4
xxxxx xxxxxx xxxxx xxxx
xxxxx xxxx
xxxxx xxxx
xxxxx xxxxxx xxxxx xxxx
xxxxx xxxxxx xxxxx xxxx
xxxxx xxxx

I cannot figure out a way to hide duplicates in a report, but ONLY if they're from the same record. If I have HideDuplicates off, it cascades the col1/col2 data down to every row. If I have it on, it will hide col1/col2 data if it matches the row above it (which is often the case), even if they're separate records. How can I have it remove duplicates for the same record only?

 

[aogail]

I have exactly this same problem. I was pleasantly surprised to see that someone had already asked my question; unfortunately nobody has answered it yet. :-( Does anyone know how to accomplish this?