Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 More

Sorting and Grouping

Use the Layout view to adjust the column widths on this report. Then, edit the Group & Sort options.

 

Try it: Edit the Group & Sort

Go to the Report Layout Tools and click on the Format tab.

Click on Sorting & Grouping.

 

Group, Sort, and Total

Select the Overdue Header.

Change the Sort to Z on Top.

 

Now, all of the overdue videos will be at the beginning of the report.

 

Save this report and name it RptOverdueRentals.

Report Layout Tools ->Format ->Group&Sort
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements

  2.6. Create reports  2.6.4. Define group headers