Access Subreport repeating records

[Level42Nut]

Hi,

I have Access 2016 report which returns a number of records from a table, each record has a TagID field which is linked to the Tags Table. A tag can be linked to a single or multiple records as below:

My Tag table contains further details about each individual Tag, and my subreport contains records from that table.

When I link my report and subreport using the TagID, I only want the the subreport to show for the first record in the main report containing the tag number.

Can anyone point me in the right direction?

Thanks.

 

[dhookom]

From you data display is that only one table?

Is the main report sorted by TagID so all of the TagIDs are together? Can you group by TagID?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[Level42Nut]

Hi,

My report was sorted by another field in my table (not shown). I didn't think to add a further grouping by TagID (haven't done access reports in a while so a little rusty!), I have now and it works perfectly. Thanks for your help.