I have created a report to be automatically circulated to a distribution list. Because of the fact that the report is scheduled, I don't want to manually manipulate it. I want to show all Potentials I am working on, with only the most recent Note associated with each Potential displayed. All I can get is a report with all Notes included, unless I include a data range. Stipulating a data range doesn't work because making it wide enough to cover all possible Potentials means that for some it will still show multiple Note entries. Does anyone know how I can do this?

Thank you.

Trevor