How to UseTWO databases in a query

N

nordenmee

I have two data bases one lists purchases and the other lists sales of
different items. How do I calculate the profit for each Item?
 
M

Marc

I have two data bases one lists purchases and the other lists sales of
different items. How do I calculate the profit for each Item?
Click to expand...

Where are you doing the calculation?
If in the sales db, link the purchases table from that db into the sales db
(under files -> get external data)
HTH
Marc
 
Top