I have a Query that has Account Code and Branch and columns for last Year , This Year and Next Year Budget. At the moment the This Year and Last Year have values. It also has a merge from a Query that brings in the Account Name.
I have another query that has Account Code, Branch and Next Year Budget (with values but no Account Name).
I want the first Query to produce a table that has values in This Year, Last Year and Next Year Budget and that the New Budget rows will also get the Account Name.
My question is do I merge (I don’t this would work) or append.
And how to I ensure that all rows in teh final table get teh Account Name
Thank You for your help