Working with Tables

Sorting Tables

You can sort the contents of a table in ascending or descending order, based on any of the columns in the table. To sort a column in descending order, click the column heading. If you want to sort the same column in descending order, click the column heading again.

Rearranging Columns

You can rearrange columns so they display in any order. To do this, click the column heading of the column you want to reposition, and drag it to the new position.

Re-sizing Columns

You can resize a column by clicking the relevant line separating the column header from the next column, and dragging it in or out to the required width.

Set Selection Criteria

Select this option to filter the table output. Enter criteria to search for records. You can also select these options:

Match any of the following - The search returns records matching any of the criteria.
Match all of the following - The search returns only records that match all the criteria you have specified.

Click More to add more filters to the query, or Fewer to reduce the number of query filter lines.

If, for example, you use the criteria contains, you can choose other criteria from the dropdown list. To run the search, click Select. To clear the selection criteria, click Clear Selection. To exit this form without executing the query, click Cancel.

Clear selection criteria

Select this option to clear any previously defined selection criteria.

Edit /rename column

Select this option to view columns currently displayed in the table. You can select/deselect columns to view. For example, you can suppress some information when entering transactions so data entry is more efficient. You can also use this form to rename a column heading, by clicking the New Heading column and editing the column's name.

Save Settings

If you have made changes to a table, and you want the changes to be retained the next time you access the table on the form, select Save settings from the table options menu before exiting the form. If you do not do this, the table resets to its default settings the next time you access it.

Reset to defaults

Select this option to reset the table to default settings.

Launching and Exporting Table Data

You can open or export the contents of a table in the following file formats:

XML for Excel
HTML
CSV
Text

Select one of these options:

Send table contents to clipboard - Paste the contents of the clipboard data in the table into an application like Word or Excel.
Output table contents to file - You will be prompted to enter a filename and a location. The information is saved in the file type that you select.

Information

The Select column, Select table, and Clear selected cells menu options are used to select the parts of the table you want to export. For example, if you only want to copy the contents of a single column in the table, position the mouse to the column heading, click the opposite mouse button, and choose Select column. If you want to copy the entire table, choose Select table. The option to Clear selected cells will clear current selections.