Hello. I have a report with a substantial amount of information coming from a query pulled from various sources. I need to figure out how to unduplicate the name of the participants included in the report. Is there a simple feature to a query that I can use to do this?
So I guess the problem is that my report is a little more complex than your average, I suppose. It is broken down by Program. Under each program lists the last name and first name of each participant, in separate combo boxes. I should add that I have a count listed for each program also. When I set the unduplicate property to "yes" for both of the name boxes, it only leaves either first name or last name left in the report. The other part is that I need to unduplicate first and last name for each separate program.