4. Click the Add button and close the Show Tables window.
The two tables should be linked with the invoice number (InvoiceNumber).
5. Select ProductID from the line items table, and drag it onto the first Field box
entry in the design specifications on the lower half of the Design View screen.
6. Place the SaleDate field from the sales table into the second column.
7. Place the Price field from the line items table into the third column.
8. Set the Sort option for the first two columns to an ascending sort.
9. Right-click the top of the window for the query designed, select Save from the
menu, and store the query as qryChartExample.
10. Test the query by clicking the Datasheet View option from the View menu, just to
make sure it??™s doing something useful.
Adding the graph to the form
The following steps detail how to create and place the new graph on the existing form. You should
be in the Design View of the form named frmProductExampleStart. The following steps take
you through the wizard to create the desired graph and link it to your form:
1.
Pages:
1479
1480
1481
1482
1483
1484
1485
1486
1487
1488
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503