Forum Discussion
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...
Greg_Deckler
Community Champion
Community ChampionOK, so what I did was create your queries in an example. I related Sales Orders (Query 1) and Sales Quantities (Query 3) on Sales Order. Then I created a matrix with Sales Order from Sales Order table, Item from Sales Quantities table and Sales from Sales Quantities table, seemed to work swell. Let me know if you want me to post some screen shots.
Yes I would appreciate it, I have searched for info on merging the queries. I need something similar to a sum-if in excel basically sum if sales order, item.