Hello,

I'm building a report that uses a view that itemizes costs on a PO. So if a distinct PO# has more than 1 component with costs attached to it there will be multiple records returned for that PO#.

For example.

PO#       Total Cost

79135    $33,016.39

79135    $480.38

However in the report I only want to bring in 1 record for that PO# with those 2 costs summed.

The Total Cost field is the only field that would be unique in a return of multiple records for a PO.

Can anyone help figure out how to do this?

Thanks!