Hello, I am new to access. I have 3 table for example table A,B,C. With each table have 1 header is Label, another header is Month (table A is Jan, table B is Feb, table C is Mar). New month will have more new labels than last month like Jan have 100 labels, Feb have 120 (so Feb have 20 new labels compare 100 Jan labels), Mar have 140 labels.
My question is how can I combine 3 tables into 1 new master table with total 140 labels in Label header or column and another 3 column is Jan, Feb, Mar?
Would someone can help me please?