Microsoft Access 2007 tutorial: Aggregate Functions

Aggregate Functions

VII. Aggregate functions

Aggregate functions are built-in functions that is used to work with numeric, text and date/time, and currency data. The aggregate functions include sum, average, count, maximum, minimum, standard deviation, and variance.

VII.1. AVG

The AVG function is used to calculate average of field or column that has a number data type, date/time, or currency data type. For example, find average of unit price column of TblProduct table.

Microsoft Access 2007 AVG Function

VII.2. MAX

The maximum value of the field or column (number, date/time, or currency data type )can be calculated by the MAX function. For instance, find the highest price of TblProduct table.

Microsoft Access 2007 Max Function

VII.3. MIN

The minimum value of the field or column (number, date/time, or currency data type )can be calculated by the MIN function. For instance, find the cheapest price of TblProduct table.

Microsoft Access 2007 MIN Function

VII.4. COUNT

The COUNT function use to count row or record in the table. For example, count products that have quantity greater than twenty.

Microsoft Access 2007 COUNT Function

VII.5. SUM

The SUM function is used to calculate total value of field or column of a table. For instance, calculate the total amount of quantity of products starting with letter A.

Microsoft Access 2007 SUM Function

Posted comments

Patrick:

Good explanations. Thank you :)

03-22-2013

Dara:

Global and local variables declaration example:
http://www.worldbestlearningcenter.com/tips/Global-variables-in-vba.htm

02-23-2013

ann:

thanks for sharing your knowledge it helps me a lot.

02-11-2013

Tamilan:

Pls post some examples for declaring and calling variables (local and global)

02-09-2013

M.somjate:

Thanks for example color code.

02-08-2013

G G Shah:

Heartly Thanks.God bless you.

01-18-2013

sek sam:

I like this website very much.
It has a lot of helpful helpful materials to learn excel programming.

01-01-2013

limocky:

useful ms access examples...
good web site to to learn access from scratch.

01-01-2013

bakery:

Thank for useful VBA example code...

12-27-2012

prasat:

Thank u for useful website..

11-03-2012

zal:

Thank for really helpful posts

10-28-2012

brasha:

Useful VBA examples for Excel. I really need them.

10-25-2012

.........................................................................................................................	Home \| Forum \| About \| Contact
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.