Shared Tutorials

Tutorials Shared by the Internet Community
Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Basic Detail

Series-Based Functions

A series or collection-based function is one that considers a particular column and performs an operations on all of its cells.
http://www.functionx.com/access/Lesson31.htm

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.

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 37.93%  55
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.34%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.72%  17
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.03%  16
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.97%  42

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.





Advertisements
Advertisements