Name: Access Issue.PNG Views: 7 Size: 11.9 KB ID: 39557" class="thumbnail" style="float:CONFIG" />
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