remove duplicates for report

[Jason]

I've set up a report based on a query which joins several tables.one table
contains multiple values and is only used for IF. How can I get the report
to only show these records once instead of everytime they exist in this last
table?

Thanks,
J.