Hi guys i need help
i have a table1 and table2 in access
table1 structure is something like this
Months / Revenue / GP
Jan / 10000 / 5000
Feb / 20000 / 2000
and table2 structure is like this
Months / Revenue / GP
Jan / 2000 / 200
Feb / 50000 / 12000
my question is how can i sum the Jan of Table1 and Table2 and Feb.
so that the total January of my Table1 and Table2 is
12000 on Revenue and 7000 on GP
same goes to February