This article was previously published under Q99934
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
This article shows you how to order data in a graph by changing the graph'sRowSource property to a query name rather than by using the SQL statementthat Microsoft Access generates.
The following steps demonstrate how to create a graph that will show allthe orders after 12/31/94, in descending order, in the Orders table in thesample 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: