Free E-Books

Double-click any field in the Available Fields list to add it to the Selected Fields list. You
can also double-click any field in the Selected Fields list to remove it from the box.
Access then moves the field back to the Available Fields list.
You are limited to selecting fields from the original record source you started with. You can select
fields from other tables or queries by using the Tables/Queries drop-down list in the Report
Wizard. As long as you have specified valid relationships so that Access properly links the data,
these fields are added to your original selection and you use them on the report. If you choose
TIP
302
Access Building Blocks Part I
fields from unrelated tables, a dialog box asks you to edit the relationship and join the tables. Or,
you can return to the Report Wizard and remove the fields.
After you have selected your data, click the Next button to go to the next wizard dialog box.
Selecting the grouping levels
The next dialog box enables you to choose which field(s) to use for grouping data.


Pages:
686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710