Microsoft KB Archive/99934

= ACC: How to Order Data in a Graph =

Article ID: 99934

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q99934



Moderate: Requires basic macro, coding, and interoperability skills.



SUMMARY
This article shows you how to order data in a graph by changing the graph's RowSource property to a query name rather than by using the SQL statement that Microsoft Access generates.



MORE INFORMATION
The following steps demonstrate how to create a graph that will show all the orders after 12/31/94, in descending order, in the Orders table in the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0):

 Open the sample database Northwind.mdb.  Create the following new query based on the Orders table, and save the query as GraphQuery:

     Query: GraphQuery Type: Select Query

Field: ShipName Table: Orders Show: True Field: OrderDate Table: Orders Sort: Descending Show: True Criteria: > #12/31/94#

NOTE: In Microsoft Access 1.x and 2.0, there is a space in the Ship Name and the Order Date field names.  Use the ChartWizard to create a new form based on GraphQuery. Select both fields for the graph and click Finish. Switch to Form view. Note that the orders are sorted by the Ship Name field. View the form in Design view. Select the graph. If it is not displayed, click Properties on the View menu to show the property sheet.  Change the RowSource property of the object frame as follows:

<pre class="fixed_text">     Object: Object Frame -     ControlName: Embedded0 RowSourceType: Table/Query RowSource: GraphQuery </li> Switch to Form view. Note that the orders are now sorted in descending OrderDate order.</li></ol>

<div class="references_section">