I have 2 tables: Members and DES
Members is 1 to many with DES
DES has a portal on the Members layout
When I produce a sub-summary report I get ALL the DES records for each members.
I want to get just the first (top row) in the portal in the report.
I suspect that I need a different DES TO ?????
Below is the portal for Rudolph Graham:
Below is the DES Sub-Summary Report.. Notice the presentation of each portal row in the
Question: "How do I show just Graham's 'top' portal record (Reinstated) in the report?