Microsoft Office Tutorials and References
In Depth Information
Adding a Total Row to the Datasheet
You can use a query as a subdatasheet. Doing so allows you to filter the data
displayed in the subdatasheet by using criteria defined in the query.
When you select a subdatasheet manually, you need to know the name of
the table or query that you use as the subdatasheet, as well as the names of
the two related fields: one in the parent table and the other in the
subdatasheet table. The two fields need to meet the requirements of related fields.
(See Chapter 6 of this minibook for all the details on related fields.)
To select a table or query to be used as a subdatasheet, follow these steps:
1. Click the More button in the Records group on the Home tab of the
Ribbon.
Book II
Chapter 1
2. Choose Subdatasheet Subdatasheet.
The Insert Subdatasheet dialog box (shown in Figure 1-18) appears.
Figure 1-18:
Use the
Insert
Subdatasheet
dialog box
when you
want to
specify the
subdatasheet.
3. Select the table or query you want to use as a subdatasheet.
To view just your tables, click the Tables tab; to view just your queries,
click the Queries tab; to view both tables and queries, click the Both tab.
4. From the Link Child Fields drop-down menu, choose the field in the
subdatasheet table that you want to use to link the two tables.
5. From the Link Master Fields drop-down menu, choose the field from
the parent table that you want to use to link the two tables.
6. Click OK.
Adding a Total Row to the Datasheet
Access has a handy feature that allows you to add a total row to a datasheet.
A total row can be used to count the number of items in a column, calculate
Search JabSto ::




Custom Search