en uk

Sorting a field Microsoft Access 2007

    Access can sort each field in ascending or descending order. Sorting a field simply rearranges the data in your report for your convenience. To sort a column (field) in a report, follow these steps:

    1. Switch to the Layout view of your report by following Steps 1-3 in the earlier section, "Manipulating the Data in a Report."

    2. Right-click in the column (field) that you want to sort.

    Access highlights your chosen column and displays a pop-up menu (refer to Figure 18-11).

    3 Choose one of the following:

    Sort A to Z: Sorts in ascending order

    Sort Z to A: Sorts in descending order Access sorts your chosen data in your report.


Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.