Hi,
I'm using excel 2016 query linked to a database.
I wanted to know if it's possible to get the query to have a calculation column based on two other columns in the query?
For example column 6 is 'QTY_ORDER' and column 7 is 'QTY_DELIVERED'. Is it possible to make column 8 'QTY_ORDER-QTY_DELIVERED'?
If so, how do I do this?
Thanks,
I'm using excel 2016 query linked to a database.
I wanted to know if it's possible to get the query to have a calculation column based on two other columns in the query?
For example column 6 is 'QTY_ORDER' and column 7 is 'QTY_DELIVERED'. Is it possible to make column 8 'QTY_ORDER-QTY_DELIVERED'?
If so, how do I do this?
Thanks,