Forum Discussion
Append Queries adding columns
Hello Everyone
When appending two queries I'm getting extra colums, even though the information is there in both initial queries and the columns are in the same order. As you can see below the Family code for S01 branch is the same as for S02 branch but instead of stacking the information it has added that info as an extra column on the end- any ideas why?
Thanks
Bailey14
With append queries order doesn't matter. You have Family Code and Family code. Change them both to capital C before you append and it will work.
3 Replies
With append queries order doesn't matter. You have Family Code and Family code. Change them both to capital C before you append and it will work.
Anonymous , your name needs to be exactly the same. Copy Family code name from one table and rename using past and make sure having exact same name and merge
