Duplicate results

[tikkat3]

I have a query that also outputs the data to a report. Both have the following fields/columns:
Project manager; Contract number; End user; Site Name; Activity Date.

The data that is out put for both query and report is correct, except for the duplication. The duplication occurs because for each Contract/End User/Site there may be more than one Activity date. (i.e. an activity date = site visit).

I am trying to get the report to produce just a single entry for each Contract number. I cannot for the life of me work out how to do it. Any help?!

 

[boblarson]

Don't include Activity Date in the initial query and then use a sub report to display the Activity dates associated with the other data (since that would be a a one-to-many relationship). Or set groupings for each item down to, and not including, Activity Date.