Access Query Problem
Posted on 2014-04-11
My company has merged with another and neither of our Sales Analysis softwares will talk with each other. However, I believe I can get the information we need through importing/exporting data from those softwares to Excel and then into Access.
Each file has similar data (Job Number, Sales amount, Customer, etc) but what I'm trying to do is instead of having all the data displayed (both company A and company B) I would like to take the sales from company and and deduct the work that company B did for company A to have a true value of the sale.