Auto deletion of duplicate records by specific field

[Islandtraveler]

:P I need to have FMP automatically delete duplicate records down to a specific field when generating a report! My database has field like division, department, goal, objective, tasks... When I generate a report that tells a division each objective it has, there are many duplications because there is a record for each task (which may be 4 to 6 under each objective) I can clean these manually but there must be a way to auto delete duplications at the objective field level for this report!?