How to UseTWO databases in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database design 0
Access MSACCESS - Sorting report based on field calculated in the report 0
Bill of materials 9
Setting Up Tables 1
Database Design 1
Access Stock In Hand query in access 2007 0
Counting multiple memberships 1
weighted average profit margin 4

Back
Top