Append Queries adding columns

[Anonymous]

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

[amitchandak]

@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

[AllisonKennedy · Accepted solution]

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]

Thank you Allison- this worked