Topics Search

Series-Based Functions

Series-Based Functions
Views: 136
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.
Sponsored Links:

Similar posts...


Built-In Functions Fundamentals

Built-In Functions Fundamentals Icon
Once again, since Microsoft Access doesn't inherently provide a programming environment, it relies on logical functions to take care of this aspect. The Choose() function is one of those that can test a condition and provide alternatives. The Choose() function works like nested conditions. It tests for a condition and provides different outcomes depending on the result of the test.
Learn: The Switch Function, Arithmetic Functions, String Functions, Date and Time, Series-Based Functions, Domain-Based Functions, Business Functions and Finance Functions.

Finance-Based Functions

Finance-Based Functions Icon
Microsoft Excel provides a series of function destined to perform various types of financially related operations. These functions use common factors depending on the value that is being calculated. Many of these functions deal with investments or loan financing.

Database Numeric Values

Database Numeric Values Icon
A number is a digit (0, 1, 2, 3, 4, 5, 6, 7, 8, or 9), a combination of digits, or a combination of one or more digits, a separator, and one or more digits. Microsoft Access supports three categories of numbers and there are various ways you can apply one to a field. You can work in either the Datasheet View or the Design View of a Table. In the Datasheet View, you can use some of the fields from the Field Templates and this options has some limitations. In the Design View, before specifying the particular numeric type of a field, first set its Data Type to Number.
Learn: Integer-Based Data Types, Decimal Data Types, Arithmetic Functions, Series-Based Functions, Business Functions, Finance Functions.

Queries-Based Functions

Queries-Based Functions Icon
These functions can also be used in queries and even included in SQL statements. The SQL interpreter of Microsoft Access can recognize these functions as long as you use them appropriately.
Topics: Queries and Built-In Functions, Summary Queries and SQL Aggregate Functions.

Introduction to Built-In Functions

Introduction to Built-In Functions Icon
Before creating a new function that perform a specific task, first find out if that function exists already. The library built in Microsoft Access is very large (one of the largest you will ever see in the industry) and provides functions that cover many subjects, including general topics, algebra, conversion, finance, accounting, date, time, and strings, etc. The available functions are highly reliable so you can safely use them.
Topics: Statistical Functions, Date and Time-Based Functions, The Win32 API.

Domain-Based Functions

Domain-Based Functions Icon
A domain-based function is used to get a value from another object and deliver it to the object in which it is being used or called. The general syntax of these functions is:

SQL Aggregate Functions

SQL Aggregate Functions Icon
Using the SQL aggregate functions, you can determine various statistics on sets of values. You can use these functions in a query and aggregate expressions in the SQL property of a QueryDef object or when creating a Recordset object based on an SQL query.

Can i do this with textboxes?

Can i do this with textboxes? Icon
What I need is. A textbox to show what number the next record in a table is going to be. I have a column called "Series". This works like cars or a television series. There is series 1, 2, 3 & so on. What I would like a textbox on a form to do is show me the current series and what number the next in series would be.

Colors of series in a Chart

Colors of series in a Chart Icon
I have a chart in one form that has a different number of series depending on which location I choose.

So, for example, if I choose Washington, there would be 5 different series, A,B,C,D,E. If I choose Florida, there would be 3 series, A,B,C.

Is there a way to lock the colors in so that A is always the same color, regardless of how many different series are present for that location? I've tried manually assigning the colors, butthat only works until I switch location-- the next place re-selects its own colors.

Manipulating Text Strings (Functions)

Manipulating Text Strings (Functions) Icon
You use string functions to manipulate groups of text data. The following are some examples of where you might use string functions: Checking to see whether a string contained another string Parsing out a portion of a string Replacing parts of a string with another value The following string functions help you do all these tasks and more.