Series-Based Functions

Tutorials Shared by the Internet Community

Advertisements


Synopsis

A series or collection-based function is one that considers a particular column and performs an operations on all of its cells.

Statistics

  • Total Hits - 27813

  • Total Votes - 132 votes

  • Vote Up - 68 votes

  • Vote Down - 64 votes

  • Domain - www.functionx.com

  • Category - MS Access/Functions

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 07:33:31

Description

A series or collection-based function is one that considers a particular column and performs an operations on all of its cells. For example, if you have a particular column in which users enter a string, you may want to count the number of strings that have been entered in the cells under that column. In the same way, suppose you have a column under whose cells users most enter numbers. Using a series-based function, you can get the total of the values entered in the cells of that column.

The general syntax of series-based functions is:

FunctionName(Series)
The FunctionName is one of those we will see shortly. Each of these functions takes one argument, which is usually the name of the column whose cells you want to consider the operation. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements