good morning to all,
I spent some time trying to add a table with a query but I can not find the result.
I have a table1:
and a query 1:
and I want to add them, for that I'm using a union query:
but with this I can not get it added, it does not overwrite the repeated values:
As you can see, values are not added.
What I want from that union is to add values, as I show in the following image.
Do you know how I can get to that? Could you give me some clue?
thank you very much for everything and geetings.