Log In
Register
Home
March 10, 2016
Offline
Hi,
In the attachment I have 2 tables - each with different columns
There is a column of an item in the 2 tables
I need a new table that will have all the items from the 2 tables in one column
How do you do that?
Thank you very much for your help! Leah
See Answer
Trusted Members
Moderators
November 1, 2018
Offline
It's not really clear to me what output you want, but your description of getting it all in one column sounds like you just want an append query to me.
March 10, 2016
Offline
I need to output a column that has all the number numbers
= 1063 data from stock sheet Y
+ 482 data from X inventory sheet
Thanks for the help, Leah
Trusted Members
Moderators
November 1, 2018
Offline
Then it appears all you need to do is remove the other columns from your 2 queries and append one to the other. Where are you stuck?
March 10, 2016
Offline
Remove unnecessary columns - I know.
The question of how to attach the 2 columns of the code - from the 2 tables
To one column?
VIP
Trusted Members
December 7, 2016
Offline
Hello Lea,
Have a look in this blog article, it shows what needs to be done to consolidate many tables into one.
Br,
Anders
Answers Post
1 Guest(s)
