Get rid of duplicate names in Report or it's query

[GMan]

I have a table that contains a list of workers, including their ID. I have
another table that lists 6 areas of work and links to the first table via ID
so I can run a query that shows where all workers work.

Some people work in more than one area. Normally, their name would appear
multiple times.

But now I need a report for anyone who shows up in Area A, B , or C and I
don’t want their names repeated. I know how to set the criteria in the
underlying query just to show the three areas, but how do I keep their name
for repeating once for each area they work in??? In this report, I don’t
care Where they work, only if they work in A, B or C. I've looked into
grouping but that doesn't do what I want.

Thanks

 

[KARL DEWEY]

Open the report in design view, click on the name textbox, right click,
select properties at the bottom of list.
Scroll down to Hide Duplicates and set to Yes.