Creating a Microsoft Access Query
Not what you're looking for?
Please explain in detail the steps that must be taken to make this query work.
Join the tables, and calculate aggregate sales for each product.
- Location is not important, total sales are what is important.
- Look at sales from the January to April only.
- Consider only the most recent year's sales.
I need to find what 11 products are the best sellers (the width, height, depth, item name, product id, sales, gross margin), using the attached database. The query needs to be limited so only the top 11's information is shown.
Purchase this Solution
Solution Summary
This solution helps create a Microsoft Access query to mind what 11 products are the best sellers. I helps find what 11 products are best sellers using a database. It helps joins tables and calculate aggregate sales for each product.
Solution Preview
Please check attachment.
Here is the query with explanations:
SELECT TOP 11 PRODUCTS.PRODUCT_ID, Sum(SALES.SALES) AS [Aggregate Sales], PRODUCTS.ITEM, PRODUCTS.HEIGHT ,PRODUCTS.WIDTH , PRODUCTS.DEPTH , PRODUCTS.GROSS_MARGIN
FROM PRODUCTS INNER ...
Purchase this Solution
Free BrainMass Quizzes
Javscript Basics
Quiz on basics of javascript programming language.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
C++ Operators
This quiz tests a student's knowledge about C++ operators.