Forum Discussion
is a subquery the appropriate method to capture this data?
Relative newbie to MS Access here. Definitely green, though i have the skills to build/modify simple scripts involving a few tables with linked/matched data points. New scenario i can't easily solv...
Except for the changed column label and addition of the word "Plan ", the second table has the same data as the first row in the first table - so it's difficult to envisage the result you're after. Do you want output that shows a single row for each Account Number that sums all the values for that account number ?