How to create a query to display sales amount

Question:

Create a query that displays the total sales amount for each region. The sales data is stored in a table called Orders with the following fields: OrderID, Region, SalesAmount and OrderData.

Answer:

The below are the precise steps performing the aforementioned job

1. Launch or load your Ms Access using the precise steps such as using the Keyboard or the computer mouse or using the search bar on the taskbar.
2. The user must ensute to explore or open the Orders table in the the noted design view
3. Clicking on the create button is the next attempt or job
4. Next is the user must click on the Query Design in the queries group as required
5. In the window of queries design environment, the user is required to drag the REGION field from ORDERS table to the FIELD row of the query grid.
6. Click the primary button of the mouse and drag the SalesAmount field from the ORDERS table to the field row of the query grid
7. Right-clicking (noted) on the SalesAmount field
8. In the query grid, select sum form
9. Try to click on the GROUP By button in the Query Setup group
10. Select REGION from the drop-down list in the previous step, that is step 9
11. Click on the run button in the Result group to execute the query

Congratulations!!!

About Author

SURF

See author's posts