Forum Discussion
Solved
Merge Columns from Multiple Tables
I have a data model with multiple sources. These sources all have the same field names. I'm needing to create a new table that merges certain columns of interest into one. Here is a simplified exampl...
You need to be using Append Queries. You can combine multiple tables and it should give you exactly what you want!
You need to be using Append Queries. You can combine multiple tables and it should give you exactly what you want!