Select Columns

Use this step of the wizard to specify the columns for which you wish to add a formula cell containing the function.

Column List


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.

Note that when an aggregate function (such as DBSum, DBAvg, DBMax, or DBMin) has been selected, the list of columns will be filtered to exclude columns that would not support the aggregate function (e.g., you can't sum a description field).