Tutorials Shared by the Internet Community
Total Hits - 36507
Total Votes - 134 votes
Vote Up - 68 votes
Vote Down - 66 votes
Domain - www.functionx.com
Category - MS Access/Functions
Submitted By - Shekhar
Submitted on - 2008-04-15 07:33:31
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:
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. More detail...