I am trying to track a weekly trend by capturing the $ value in our pipeline at the end of each week and have it populate into another table. I have a "Projects" table, a "Sales Team" table, and a "Reports" table. Projects are assigned (linked) to so...