3305 Main Street Ste 019 Vancouver, WA 98663

Database Functions

Database functions return distinct values or aggregate values from your database. These functions are often an integral part of a report design.

Function Description
DBAvg Returns an average value from a column in a table. The rows that are included in the average can be limited by applying a filter.
DBCount Returns the number of rows in a table. The rows that are included can be limited by applying a filter.
DBFind Locates a specific row in a table and the returns the value for a specific column. The row can be identified using a combination of a filter and an offset. First the filter is applied to the rows in the table to find matching rows. The offset is used to identify the row number to use.
DBLookup Returns the value for the specified column in the row uniquely identified by the table’s primary key. A value must be supplied for each column in the primary key.
DBMax The DBMax function returns the largest value from a column in a table. The rows that are compared can be limited by applying a filter.
DBMin The DBMin function returns the smallest value from a column in a table. The rows that are compared can be limited by applying a filter.
DBSum The DBMin function returns the sum of the values from a column in a table. The rows that are compared can be limited by applying a filter.