Aggregate Amounts and group ID together

[shoro]

I was wondering if there is any way to identify duplicates IDs in a table and flag or group them to as one ID and aggregate its amounts. I tried doing group by but it doesn't seem to be working as the rows are not identical. I will appreciate any suggestions.


Thanks,

[JoeM]

You can do it through an Aggregate Query. The key is to only include the fields you want to see in the query, not the entire record (row). So you will only include the fields you want to Group By and the fields you want to Aggregate.