Report not grouping correctly? hiding duplicate values

[XelaIrodavlas]

Hi all,

I have a table of Document references, and am trying to print an index of all documents on the system.

I've grouped the records by DocumentType, and this has produced the desired result, see JPG1.

However the report only looks like this when each document has a different name to the one above it. When I have multiple documents with the same name (reasons outside of my control) Access only shows it for the first line, and leaves the rest blank (see JPG2).

I kind of get why Access does this, but my user wants to see the name repeated for each instance, is there a way I can do this?

FYI:
JPG3 shows the grouping applied, you can see I have sorted the groups by Doc name, which ensures all docs stay together. This doesn't seem to be responsible for the problem though - when i remove the sort, i still get the same issues but in patches all over the place, it's a right mess.

All ideas appreciated
Many thanks,

 

[XelaIrodavlas]

Found it!

In the Format tab on properties for the Doc Name control, there's an option called 'Hide Duplicates' that was set to Yes by default.. I switched it to No and it's problem solved.

Woohoo