3305 Main Street Ste 019 Vancouver, WA 98663

Function Options

This step of the wizard allows you to control how the function will be inserted into your worksheet.

Column Layout

  • Left to right - When more than one column has been selected (and therefore multiple formulas will be inserted), this option tells Liberty Reports to add the formulas starting in the current cell and then add each additional formula in the cells to the right.
  • Top to bottom - When more than one column has been selected (and therefore multiple formulas will be inserted), this option tells Liberty Reports to add the formulas starting in the current cell and then add each additional formula in the cells below it.
  • Fill down formulas - When checked, and the formula is being inserted in a column adjacent to a query or other list, the formula will be automatically copied down to each row of the query or list.
  • Include column captions - When checked, the currently selected cell will be used to store a caption. If the Left to Right option is selected, the formula will be placed in the cell below the caption. If the Top to Bottom option is selected, the formula will be inserted in the cell to the right of the caption.

DBFind Options

The following set of options only appear when the DBFind function has been selected.

Matching

The DBFind function returns values from a specific row in the table yet the conditions that you supply might be satisfied by more than one row. In order to narrow the results to a specific row, the following options are available:

  • Find the first match
  • Find the last match
  • Find a specific match

Note that what is considered first or last (or any sequence in between) is determined by the database. In some cases, records will be ordered according to their primary key. In some databases, records do not have a predetermined sequence.

Specific Match

This set of options appears when the Find a specific match option is selected. The specific match will be based on identifying which record (among those which satisfy the conditions) to return values from by identifying a row number.

  • Row number to use if multiple rows are returned
    • Type - Select either Literal Value if the value will not need to change, or Cell Reference if you want to control the value based on a value in a cell on your worksheet.
    • Cell or Value - If Type is Literal Value type the desired row number. If Type is Cell Reference, type a valid cell reference for the cell containing the desired row number.
  • Starting from the first row and working downward - The row number will be relative to the first row.
  • Starting from the last row and working upward - The row number will be relative to the last row.