Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Can someone help with this query in Microsoft Access?

I need to finish the last part of my assignment in Access, before I can move on with the Excel portion. Cannot for the life of me figure this out, but I need to run a query to figure out gross profit for each type of tree. It seems like not all the trees in inventory were sold and so that is throwing me off.

I uploaded Access to Google Drive and a download link is available there, and below is a link to the instructions for this query. Any help will be greatly appreciated!

Access File:

https://drive.google.com/file/d/0B7eIYSolZ411MDhTb...

Instructions:

http://imageshack.us/a/img189/699/y7dk.png

1 Answer

Relevance
  • AJ
    Lv 7
    8 years ago
    Favorite Answer

    You shouldn't be calculating gross sales from your inventory table. It should be calculated from your invoice tables.

Still have questions? Get your answers by asking now.