Posted on 2011-05-05
I have a query I am using for a report that returns info from two separate tables. Currently the query will return results based on functionname =management summary and new_typeofopportunity=Aircraft Placement and it only returns one row of data per dealname or accountbase.name. I need to change this so that when the data is returned, the data returns only one management summary per dealname based on MSN. In other words, I have an activity report that users enter data to and assign to the deal name. I am creating a report that when run, will group by MSN and only show the last management summary entered for a particular account. So I might have 4 accounts entering management summaries. I only want to see one summary per account. Any help would be appreciated.