Formatting to only show name once for many records...

[Rick's News]

I have a report based on a query of two tables.
In the report someones name can appear next to each item overdue, but I only
want it to appear once...

Each ID can have many records under it...

Like this:

First Name:
Due Date:
Due Date:
Due Date:
Due Date:
Second Name:
Due Date:
Due Date:
Due Date:
Due Date:
Due Date:
Third Name:
Due Date:
Due Date:
Due Date:

How do I do this in a report?

Thanks in advance!

-Rick

 

[Sirocco]

Every field in the report has a "Hide Duplicate" property. Set it to Yes
for the field that you want to appear only once. OR, if you group on name,
put "name" in the respective section header, the other fields in the detail
section. Both of these 2 techniques will produce similar looking results.

 

[Rick's News]

Thanks, that is just what I needed!

Every field in the report has a "Hide Duplicate" property. Set it to Yes
for the field that you want to appear only once. OR, if you group on name,
put "name" in the respective section header, the other fields in the detail
section. Both of these 2 techniques will produce similar looking results.