Microsoft KB Archive/103270: Difference between revisions
(importing KB archive) |
m (Text replacement - ">" to ">") |
||
Line 45: | Line 45: | ||
<pre class="FIXEDTEXT"> Field: Customer ID Ship Via Order Amount Order Date | <pre class="FIXEDTEXT"> Field: Customer ID Ship Via Order Amount Order Date | ||
Total: Group By Group By Sum Where | Total: Group By Group By Sum Where | ||
Criteria: | Criteria: >=#1/1/92# </pre></li> | ||
<li>Create a new query based on the Total Sales and 1992 Sales queries.</li> | <li>Create a new query based on the Total Sales and 1992 Sales queries.</li> | ||
<li>Join on the field [Customer ID]. Double-click the join line and select the option Include ALL Records From Total Sales.</li> | <li>Join on the field [Customer ID]. Double-click the join line and select the option Include ALL Records From Total Sales.</li> |
Latest revision as of 17:42, 20 July 2020
ACC1x: Graphing Current Sales Compared with Accumulated Sales |
Q103270
The information in this article applies to:
- Microsoft Access versions 1.0, 1.1
SUMMARY
This article describes how to create a graph that displays each customer's total sales for all years compared with their sales for 1992. The data in the graph is also broken out according to the company from which the orders were shipped.
This example uses tables in the sample database NWIND.MDB.
MORE INFORMATION
How to Create the Queries
Create the following new query based on the Orders table, and then save the query as Total Sales:
Field: Customer ID Ship Via Order Amount Total: Group By Group By Sum
Create the following new query based on the Orders table, and then save this query as 1992 Sales:
Field: Customer ID Ship Via Order Amount Order Date Total: Group By Group By Sum Where Criteria: >=#1/1/92#
- Create a new query based on the Total Sales and 1992 Sales queries.
- Join on the field [Customer ID]. Double-click the join line and select the option Include ALL Records From Total Sales.
- Join on the field [Ship Via]. Double-click the join line and select the option Include ALL Records From Total Sales.
Drag [Customer ID], [Ship Via], and [SumofOrder Amount] from Total Sales to the query grid. Add the label Total: to [Sum of Order Amount] as follows:
Total: [SumofOrder Amount]
Drag [SumofOrder Amount] from 1992 Sales and add the label 1992 as follows:
1992: [SumofOrder Amount]
- Run the query to verify that it works correctly and then save it as Sales Summary.
How to Create the Graph
- Create a new, blank report based on the Customers table. Display the field list and drag the Customer ID field to the detail section.
- Create a new graph in the detail section by selecting the Graph tool from the Toolbox and drawing an unbound object frame.
- Make the following selections in the Graphing Wizard:
- Data source: Sales Summary
Totals: Sum - Which field(s) for data and labels: Ship Via, Total, and 1992
- What labels do you want: Ship Via
- What labels for the legend: Total and 1992
- Link the Graph to the Report: Yes
- Which fields will link: Customer ID = Customer ID
- Data source: Sales Summary
- Save the report and then preview it. For each customer, the report should display a graph of that customer's total sales and 1992 sales organized by the shipping company.
Additional query words: overlay multiple summary
Keywords : kbtool
Issue type : kbinfo
Technology :
Last Reviewed: November 4, 2000 |