I'm trying to design a query that could show (in a report or on a form) the number total of one of our products, for example sold in a particular month. The problem is that in some circumstances, we sell components separately, so that an order (and order detail) could include complete products or components only or both. The final tally should compute the components into products (in this scenario). I knew I needed a junction table and think I constructed it properly but I'm missing something about how to get to the final result. The date criteria isn't important here. I get zero results with this query. I had lookup fields in the junction table and realized that could be a problem so I changed that so it only enters the ID field and that didn't helpe.
Any help would be appreciated
Thanks
![]()