I am taking two inventory tables and combing them into 1 Query.
What I am trying to do is take the "Purchase Order #" field from the tblPO and the "Sales Order #" field from the tblSo table and merge them into 1 column.
This way I can start to look at the inventory data as if it were like an accounting worksheet with PO being positive numbers and SO being negative numbers.
I assume this is a newbie question, but I just can't figure it out.
Thanks for any and all help