Combine 3 tables into 1 total (1 Viewer)

Infinite

More left to learn.
Local time
Today, 07:08
Joined
Mar 16, 2015
Messages
402
Hello! I have 3 tables, and each table (for reasons) has individual sales, quantity, etc, etc. Now, how would I combine each of those into 1 total? Each of those has a different ID, and I have a query that has all those IDs in 1 query. I just don't know how to have the totals in 1 column of 3. Thanks!
 

plog

Banishment Pending
Local time
Today, 09:08
Joined
May 11, 2011
Messages
11,613
(for reasons)

I noticed that the word 'good' wasn't there. So the answer is you combine them into 1 table by using an APPEND queries based on the other 2.

Sounds like a poor structure is coming back to haunt you.
 

Infinite

More left to learn.
Local time
Today, 07:08
Joined
Mar 16, 2015
Messages
402
I noticed that the word 'good' wasn't there.

for "good" reasons :) I didn't say good because I know it's not the correct thing to do. Thus, it's not good, but, it is "reasons" for doing it.

I have decided to split a certain part of my sales into 3 different sections. 2 different (maybe 3) online venues, and 2 physical stores. And now after typing this, I have decided it's a very stupid idea to do that. Guess I get to get and redo that part of my database ;) Good thing I have only been working on it for the past day, not a week. Then I would be way to far down the rabbit trail to turn back.

Thanks! You probably definitely saved me some hassle in the future!
 

Users who are viewing this thread

Top Bottom