Series-Based Functions

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial 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
  • Total Hits: 19376

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 171 votes

  • Category: MS Access/Functions

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

  • Submitted By: Shekhar

  • Set as Favorite

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.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 33.92%  58
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.53%  18
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 10.53%  18
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 10.53%  18
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 34.5%  59

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