Table of Contents

Sort Data in Any Order

Data Access Studio lets you sort any column or set of columns.

To

Do this

Sort a column from smallest to largest

Right-click the Column Header. Click Sort Ascending.

Sort a column fromlargest to smallest

Right-click the Column Header. Click Sort Descending.

Sort many columns from smallest to largest

Hold the CTRL key down and multi-select the columns you want. The order in which you click the columns will determine which column is sorted first. Right-click the Column Header. Click Sort Ascending.

Sort many columns from largest to smallest

Hold the CTRL key down and multi-select the columns you want. The order in which you click the columns will determine which column is sorted first. Right-click the Column Header. Click Sort Descending.

Sort by both smallest to largest andlargest to smallest for multiple columns

Hold the CTRL key down. Right-click the Column Header. Pick a different sort than the one it shows.