I need to add the total $ of multiple records, but only if the ID #ers match. I think I am making this harder than it should be, but I am stumped. Essentially this is a summary field, but within the table, not part of a relationship.
PID is a numeric field, Total TCV is a currency field
If [PID #] is the same, add the [Total TCV]