Hi,
I have the function below in my main query but it only sums the same fields that appear in both my sub queries leaving the other fields blank.
Sum([TotalOrdersSHPT1]+[TOtalOrdersSHPT2])
I have two shipments so my first query reflects the product Ids and total quantity found in shipment1 while the other query reflects what we've had for shipment2. Because both queries have the same field "product Ids", I've created a third query to group both queries by Product Id and sum the total quantity received. And although my query reflects the product IDs received, it only sums product Id fields that are found in both shipment1 and shipment 2, leaving the other fields blank.