Topics Search

Series-Based Functions

Series-Based Functions
Views: 134
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:

Getting the name of a chart series name

Getting the name of a chart series name Icon
I have a form containing four check boxes and a chart. I use some VBA code to update the chart based on the check box values. Sometimes one check box is selected, sometimes two and so on. Depending on how many check boxes are selected the colours in my line chart change for each series. I want to keep the colour consistent for each series.
With this in mind, Im trying to add some code that runs through each of the four chart series names and changes the colours to a specified colour but I'm not sure how to refer to the series name in code.
I have some code as follows:...

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.

MYSQL functions within Access

MYSQL functions within Access Icon
As we know UUID() and NOW() functions are MySQL functions. I like to set equivalent functions and features in Microsoft Access.

What will be the same functions and where to put?

Showing a selected value from a field

Showing a selected value from a field 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