Linking Tables One to Many - Cumulative Value Issues

Hi All,     I have two queries that I have linked as a 1 to many ratio by Sales Order # as the unique identifier.   Query 1 - Has sales order for each individual row without "sales value"$ amoun...