The Sum function is used to calculate the total value of a field or column in a table or query. A field or column must has a data type of number, date/time or currency. For instance, calculate total value of the SubTotal field of Query1 by category. To do so, follow a shown figure below:
The Avg function is used to calculate the average of a field or a column that has a data type of number, data/time or currency. For example, calculate the average of the UnitPrice field of TblProduct by category. To do this task follow the figure below:
The maximum value of a field or column(number, date/time, currency data type) can be calculated by using Max function. For example, calculate the highest unit price of products. To do that, follow the figure:
The minimum value of a field or column(number, date/time, currency data type) can be calculated by using Min function. For example, calculate the lowest quantity of products that have names starting with A letter. To do that, follow the figure:
The Count function is used to count to row or record in a table or query. For example, count the products that have quantity greater than twelve.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: