Columns to Count

This step only appears when you have selected the DBCount function. Use the options in this step to determine the type of count that you want from the table you selected:

Count all rows in "table-name"

Select this option to return a count of the records in the table that meet the conditions you specified (if any).

Count the number of distinct values in each selected column

Select this option if you want the number of distinct values rather than the number of records. For example, if your table contains several thousand rows but only five different values have ever been stored in a specific column, the count of the distinct values in that column would be five.

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).

You may only select columns when the second option has been selected (Count the number of distinct values in each selected column).

This step only applies to the following functions:
  • DBCount