Group records together

In a data view it is very easy to group records. Simply click on the column heading you wish to group by and drag it to the area just above the column headings labeled "Drag one or more columns here to group by that column". If that area is not visible, right click on the view and make sure the "Group By box" menu item is ticked.

To sub-group by another column, drag that column to the same area, e.g.:

To remove a group by, drag the column away from the Group By Box area. You can also do grouping by right clicking on the view an selecting Group By.

Home