I am having trouble getting the Item Cost to populate on the query pictured. There are item costs listed in the tblInventory table, but the field comes back blank in the query. The relationship between tblInventory and tblPurchases is set to #3 (Join all from tblPurchases (right) and only those records from tblInventory (left) where they are equal. Does anyone have any ideas what I have done wrong?
35.9 KB Views: 9