3305 Main Street Ste 019 Vancouver, WA 98663

Column List

Column List

{%1}

The Columns in table-name column displays the caption that will be used for the column. The Internal Name column displays the name of the column in the database. Depending on the type of database, this may be a somewhat cryptic name.

Check the box for each column that you wish to create a formula for. Each column that you select will result in a separate cell on your worksheet being populated with a formula that contains the function that you selected.

You may sort the list of columns by clicking any column header. Clicking a column header a second time reverses the sort direction. Clicking it a third time will return the column list to context order. This is the order in which the columns naturally appear in the database table (from left to right).

Sample Values

This list shows a list of distinct values from the column that is currently selected in the column list. This preview allows you to see the types of values you can expect if you choose to use the column in your formula.