I am brand new to Access and am having trouble figuring this out. Linked column isn't returning correct values.
Linked column (Batch) has exact same header/values for both tables, as do the Lines for each Batch.
The right table is what I would like the Query to return (correct values). The left is what it is returning. The total value for Line 1 is appearing twice for both Line 1 and 2, and the same for Line 2 value.
The data sets are very simple.
Dataset1: Batch, Line, Total
Dataset2: Batch, Line, Sampled